Query on a date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table called tblUnAvail with LName, FName, Start
and Stop fields. Another table called tblSchedule displays
Sun - Sat as text fields as well as the date range of the
week displayed using Start and End fields. The Start and
End fields are in the header so they don't display with
every record. Here's what I'm trying to do:

If a person is going to take time off I put them in the
tblUnavail with appropiate dates. I'd like for a query to
update the correct text box in tblSchedule with "LV"
(without quotes). For example; if Joe take July 26 to July
30 off I'd like the query to update the tblSchedule for
those days with LV displayed. Thanks in advance.

RP
 
No replies?? Good news. I figured it and it works. It took
about 10 hours to figure out. Anyone who wants the
solution just post a response to this message and I'll
post the SQL statements.

RP
 
Back
Top