C
cookzter
I'm having a terrible time, this didn't sound difficult when I said I
would do it but now I'm NOT able to make this work. I'm working on a
database that keeps track of swimming pool inspections. In table A I
have a list of the facilities. Table B is linked to table A by ID and
contains 2 dates, 1 for when the pool operator submitted their monthly
report, the other for when the bacteria sample was received from our
lab. This is a one to many relationship because I have to keep track
of dates for each month, so there should be a record for each month in
table B. In order for the pool to remain operational it must have a
current monthly report and bacteria sample. The problem I'm having
is, I need a query that will pull out those facilities in table A that
do not have a record in table B for the previous month. I've tried
this query a million different ways but can't get what I want. I
either don't get everything or I get the records for previous months.
Does anyone have any idea how I can get the data I want?
Thanks in advance!
would do it but now I'm NOT able to make this work. I'm working on a
database that keeps track of swimming pool inspections. In table A I
have a list of the facilities. Table B is linked to table A by ID and
contains 2 dates, 1 for when the pool operator submitted their monthly
report, the other for when the bacteria sample was received from our
lab. This is a one to many relationship because I have to keep track
of dates for each month, so there should be a record for each month in
table B. In order for the pool to remain operational it must have a
current monthly report and bacteria sample. The problem I'm having
is, I need a query that will pull out those facilities in table A that
do not have a record in table B for the previous month. I've tried
this query a million different ways but can't get what I want. I
either don't get everything or I get the records for previous months.
Does anyone have any idea how I can get the data I want?
Thanks in advance!