different types of queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a query that will split all my company’s, and its sales, e.g.

I can get the query working by DATE (DDMMYYYY) ,I want an breakdown of the
all the different sales in all the campanys,

13/11/2004 Campany1 sales Total
13/11/2004 Campany1 Sale2 1202
13/11/2004 Campany1 Sale3 85150
13/11/2004 Campany1 Sale4 54
13/11/2004 Campany1 Sale5 415


This is want I want for each of the company’s Daily I not want to filter for
the one I want.

Also I do not want to enter all the companies in the queries
I want a query that select the date I want and then splits all the company’s
I have a columns that states which company they are,

Can you help me with this?

Thank
 
I need a query that will split all my company’s, and its sales, e.g.

I can get the query working by DATE (DDMMYYYY) ,I want an breakdown of the
all the different sales in all the campanys,
Click to expand...

Could you explain what you mean by "working by DATE"? Are you using
the date field as a criterion, or what?
13/11/2004 Campany1 sales Total
13/11/2004 Campany1 Sale2 1202
13/11/2004 Campany1 Sale3 85150
13/11/2004 Campany1 Sale4 54
13/11/2004 Campany1 Sale5 415


This is want I want for each of the company’s Daily I not want to filter for
the one I want.
Click to expand...

I am not sure I understand what is in your table. I *THINK* a Totals
query, grouping by Company (campany??) and by date will do what you
want, but I do not know what your "sales" field contains and whether
you want it in the total.

What fields actually exist in your table?
What do you want totalled?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top