If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query on a date range
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 |
#2
|
|||
|
|||
Query on a date range
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 -----Original Message----- 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 . |
#3
|
|||
|
|||
Query on a date range
I have similar problem. Thanks for any code assist. Doug
" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date reference as criteria in query | Tim Brown | Running & Setting Up Queries | 1 | June 21st, 2004 01:01 AM |
query based on date range? | Tammy | Setting Up & Running Reports | 2 | June 7th, 2004 08:31 PM |
Date query in Dialog box question | joe | Running & Setting Up Queries | 1 | June 5th, 2004 12:52 AM |
Parameter Query on date using MS Query | Brian | Links and Linking | 0 | January 27th, 2004 07:05 AM |
Offset formula to add range depending on date | Todd | Worksheet Functions | 3 | November 22nd, 2003 06:12 PM |