Just have a question about Access Quries.
I want to create a query where I have to count the number of medication has been given on "PRIM_CARE" in the month of June. I have to archived this data from the files. so means I have 30 files, each for each day. Also, I have about 30 tables, again each table for each day.
So, my question is how to combine all the count together and have a report where it tells you the total count for each medication, and the grant total.
I can do it for one table, but not sure if we could add more than one table in the query, remember the field name in each table is the same. please take a look of my query, which works well for this day, and thanks for your time.
Expand|Select|Wrap|Line Numbers
- SELECT A060107A.Field7, Count(A060107A.Field7) AS CountOfField7
- FROM A060107A
- WHERE (((A060107A.Field1)="PRIM_CARE"))
- GROUP BY A060107A.Field7;