Counts of Certain Records in a Query

[CCIDBMNG]

I was wondering if someone could tell me an easy way to do what I'm trying to do. I have a table with orders in it. There are 2 fields in that table that I need counts for. Received date and exported date. I need to count how many orders we receive each day and how many we exported. But I need the counts by office. Which is another field in the table. I then need to generate a weekly report to show the totals for each day that week. Another problem I have is we have different order tables for each client and I need to do this for each client but run them all in one report. Could someone please help.

 

[CCIDBMNG]

I have to have separate tables for each client because we input the data and send a file to the client and each client wants different fields. If all the fields were the same or somewhat similiar I would have them in one table. But thanks, I think I figured out a way around it.

 

[RV]

>I have to have separate tables for each client because we input the data and send a file to the client and each client wants different fields.<

That's a bad (no) reason to create different tables for one and the same entity.
Never build your database structure to each user/customer/client but look for the common demands/wishes and use the 80/20 rule (at most 80 percent of functionality is really necesarry, the rest is "nice to have" (or even not so nice to have...)

Try to create ONE table which consists of all fields your clients have in common.

Use (if it's suitable) a report tool to "export" the data the clients are asking for.

RV

 

[CCIDBMNG]

Unfortunetly I must have different tables but we did just add a transaction table which shows what time something is changed with an order. It shows all of our entries for each client and what was done with the order. Whether it was received, exported, etc. So I am using that table. Now the problem I am having is I created a query to show the client, office, and number of orders invoiced. And a query to show client, office, and number of orders received. How do I combine the two? I tried using joins but that doesn't show all the data sometimes. Any ideas?

 

[CCIDBMNG]

Ok scratch that last reply I figured out how to combine what I needed with a union query. Now can I create an append query or a crosstab query based on the union query. I'm not familiar with these types of queries.