Query: Between previous And Date()

[jwr via AccessMonster.com]

I have five date fields that are used to collect records by a query. Any
ideas on combining the fields or something else to streamline the query, e.g.
date1, date2, date3, date4, date5 reflect termination dates. If the client
has been here multiple times, then each time/date is posted upon departure.
(Oct13, Sept01, July08, May03 and Feb19). Of course, if the client had been
there just once, then only one date would be posted.

thanks jwr

 

[Ed Warren]

First problem is putting information in date1,2,3 rather than in a table
e.g. (Limited to 5 employement cycles and/or will have to add new fields to
your database)

Employment Record
EmploymentID EmployeeID DateHired DateDeparted .... other stuff
about the hiring/firing

Now you can get your answers faster and get more answers.
example how many times have we hired/dismissed John?
.....
Ed Warren.