how to create summative totals in one query access from one table?

[ayupchap]

I have actually posted this as part of another thread but feel it might be best to open it as its new one, this has really thrown me and close to just doing this in Excel

I have to summarize many different fields for this summative report. For example I need to group together the following and have no idea how to do this in one query, I will list the field and what it needs to show:



Grade - Summarized by number in each grade
Accepted - Those that have accepted (marked as "YES" in the database in the ACCEPTED field)
Declines - Those that have not accepted (marked as "NO" in the database in the ACCEPTED field)
Not replied - Those that have not let us know yet (marked as "blank" in the database in the ACCEPTED field)
Withdrawn - Those that we have or themselves have withdrawn (marked as "TRUE" in the WITHDRAWN field)


Now I can run these as individual queries and get the right results but I can not do it in one query (it changes the other field results), is there anyway of doing this? Simple step by steps would be great as I am not great at queries. Also When I did make them individually I couldn't put them together in a report as the queries were not linked?

Any help very much appreciated.

[burrina]

Hi, you need to make what is called a subquery. You use a already created query and place it in a new query and then insert your criteria.

HTH

[ayupchap]

Oh great. I created individual queries but it wouldn't let me put them together in one query, is there something I am doing wrong?

[burrina]

What do you mean, it would not let you? Add the former query into your grid, the fields and any criteria you need. If you add other tables or queries, you will need to link them correctly by the correct field, normally Primary Key.

[ayupchap]

Sorry I didn't make myself clear, I guess I am not good at explaining these things

I have made 3 different queries that return the correct results. When I put them together in another query i get the following error message:

You have chosen fields from record sources which the wizard can't connect. You may have chosen fields from a table and from a query based on that table. If so, try choosing from only the table or only the query.

[burrina]

Are those queries linked to each other in the query grid?

[ayupchap]

Oh, no they are not. How do I do that? Sorry I'm not good with these, really appreciate your help. I know how to link tables etc but never linked queries. Do I need to ensure the primary key is included in each query?

[burrina]

YES, That is what your NORMALLY link by.

[ayupchap]

Yes thats what I thought. I do always link that way but never have I linked two queries together so unsure how that process works.

[ayupchap]

Thanks so much for your help by the way. I think I just worked out my stupid mistake.

Scott

[burrina]

Glad you got it sorted out. Good Luck With Your Project.