Microsoft Access Programming.. How to Group???

[Krueger81]

Hello,

I have this database hereand well I am having problems with the very last thing on my list. Here is the question it's asking me to do.

Open The Salary Statistics Query in Design View. Modify the Query so that the records are grouped by the Bonues Quota Field.

How would I go about doing that. I think I have done a good job so far but this really got me stumped.

Thanks for any help you guys can give me.

Phil

 

[Descartes]

There is a more appropriate forum for this.

Anyway, just choose "Group By" for the "Total" part of the field in the design view.

 

[Krueger81]

aehm..

there is no total part?

Thanks
Phil

 

[Hector13]

Originally posted by: Krueger81
aehm..

there is no total part?

Thanks
Phil

right click in design mode and choose "totals".

 

[Hector13]

or just change your SQL to be:

SELECT [Recruiter Employees].[Bonus Quota], Min([Recruiter Employees].Salary) AS MinOfSalary, Max([Recruiter Employees].Salary) AS MaxOfSalary
FROM [Recruiter Employees]
GROUP BY [Recruiter Employees].[Bonus Quota];

 

[NikPreviousAcct]

You start by posting in the correct forum.

 

[KLin]

Originally posted by: Krueger81
Hello,

I have this database <A class=ftalternatingbarlinklarge href="http://www.computersunited.com/files/Elsa.mdb" target=blank>here</A> and well I am having problems with the very last thing on my list.  Here is the question it's asking me to do.

Open The Salary Statistics Query in Design View.  Modify the Query so that the records are grouped by the Bonues Quota Field. 

How would I go about doing that.  I think I have done a good job so far but this really got me stumped.

Thanks for any help you guys can give me.

Phil

Krueger,

Take a look at Salary Statistics query

Is that what you wanted to do?

 

[Krueger81]

Hector13,

you are the man. thanks. And to all you Forum Wanna Be Mods. Get a life.

Phil

 

[Krueger81]

Originally posted by: KLin

Originally posted by: Krueger81 Hello, I have this database hereand well I am having problems with the very last thing on my list. Here is the question it's asking me to do. Open The Salary Statistics Query in Design View. Modify the Query so that the records are grouped by the Bonues Quota Field. How would I go about doing that. I think I have done a good job so far but this really got me stumped. Thanks for any help you guys can give me. Phil

Krueger, [L=Take a look at Salary Statistics query]http://mywebpages.comcast.net/kalinder/Elsa.mdb">http://www.computersunited.com/files/Elsa.mdb" target=blank L</a> Is that what you wanted to do?

yub,

you rock 🙂

Phil

 

[OffTopic1]

Click the E (Total) icon to turn on group by & chose your option.

 

[KLin]

NVM

 

[Descartes]

Originally posted by: Krueger81
Hector13,

you are the man. thanks. And to all you Forum Wanna Be Mods. Get a life.

Phil

That's a great way to get help, moron; especially since I gave you the bloody answer in the beginning.

 

[OffTopic1]

Originally posted by: Descartes

Originally posted by: Krueger81
Hector13,

you are the man. thanks. And to all you Forum Wanna Be Mods. Get a life.

Phil

That's a great way to get help, moron; especially since I gave you the bloody answer in the beginning.

SELECT STRCONV ('be nice...not everyone are computer litterate', 2) AS [Lower Case];

 

[Krueger81]

Originally posted by: Descartes

Originally posted by: Krueger81 Hector13, you are the man. thanks. And to all you Forum Wanna Be Mods. Get a life. Phil

That's a great way to get help, moron; especially since I gave you the bloody answer in the beginning.

are you offended?

Anyway I got the help let it die thanks to all the people that helped me. Even you Descartes. I am not familiar with Access that much and just wanted to get it done.

Thanks
Phil