Hi All...
I need some help here and hope someone can help me ...
I've created a table (with some data), one of the data is number
Example
Name, Category, Buy
Alisson A 100
Barn B 100
Darren A 150
Elise C 100
Fuller B 100
Gill B 150
Then I create a query
Query 1 is total of [buy] that is 700
Query 2 is total of [buy] by [category]=A that is 250
Query 3 is total of [buy] by [category]=B that is 350
Then I create a report based on query 1 since its the biggest amount
When I group by category Access can give me answer by category.
My question is :
If i need the data from query 2 to be in my report, how can i do it?
Or maybe I just need 1 query rather than 3?
Hope the info is enough ...
Trillion Thanks ...