Creteria

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,
I like to create a query which shows current day and
yesterday records.
---------------------
For example,
I have 10 patients came to my office yesterday, 05/12/04.
Eight of them are Ok and they went home righ away.
Two patients( Linda and Jonh) still be in hospital.
_______________________

Today (05/13/04), I have 10 patients comes to my office.
_______________
I would like to have a query which shows 10 patients'names
(for today) and two(Linda and Jonh) who came to hospital
yesterday, but they are staying in hospital.

What criteria I need to use? Please.

Thank you
Loi
 
I am going to assume you have a table with the following
fields:patientname, visitdate, hospitalind

create a query with these fields. it should look
something like this:

field: patientname visitdate hospitalind
show: x x x
criteria date()
lines: Y

With criteria on different lines, you get OR criteria. So
you will get a list of patientname, visitdate and
hospitalind for patients who visited today, or have
hospitalind set to Y (meaning they are still in hospital)
 
Back
Top