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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query with unrelated tables 7
Date update in append query 6
I only need the first date not all 3 1
Date range queries 2
Extract data for a date plus tomorrows date 3
query based on date ? 1
Autofill inside if/then statement 2
query on date 1

Back
Top