Running query behind the scenes

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

I have a field for Date of Last visit. I want to keep a
running list of the dates per patient, even though only
one date will be visible on the form at a time. I don't
want to have to insert a subform. perhaps there is
another way.

Right now, I have a field in the main table: [Dateof
lastvisit]. I created another table only for dates:
[Officevisit ID], [HOSPITAL ID], [dateoflastvisit].

Thanks in advance!
 
I want to keep a
running list of the dates per patient, even though only
one date will be visible on the form at a time. I don't
want to have to insert a subform. perhaps there is
another way.
Click to expand...

Look up help for DMax()


Tim F
 
Back
Top