Creating a query using mutliple tables

[andrewmo]

Hello

I am trying to find a count of all emergency room patients that meet the following criteria using query design

Acuity 1
Arrival between 12:00:00 AM and 12:59:59 AM
Show medical record number



I have 9 tables each table represents each month and each table has the exact same fields/headers, but for some reason access doesn't recognize the relationship.

Is there a way to pull a total count of patients that meet that criteria from the 9 tables without having to do each table(month) individually?

Thank you

[alansidman]

Before a solution to your query is even discussed, it appears that you have a normalization issue. You should not have a separate table for each month. Read this discussion on database design. I think that your first priority should be to normalize your data. Once that is complete your query issues will be diminimus.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

Alan