Search results

I tried to go with a different approach that seemed to be working better. I have the 2 tables combined with a one to many type relationship Each of the 31 days runs a variation of the following formula Appt01: IIf([Scheduled]<=ELookUp("DStamp","tblMainInformation","[ID] = 1") And...

I didn't think to capture this on the screenshot, but, the Daily Queries to Alpha List is linked by SSN in tblAlphaList and tblSchedSSN in each of the qryScheduleDay##. Option 2 is enabled. All records from tblAlphaList and only the matching in qryScheduleDay## are displayed.

The database keeps all of the information for personnel in the shops, manning rosters and what not. The training monitors requested that I build a calendar type function to allow them to print out 7, 14 and 31 day forecasts so people can see what is coming up (appointments, events and so on) as...

I have a query that I think may be too much for access to handle (unlikely) or is poorly designed and causing Access to work too hard to find the information (most likely). The 2 tables involved with this query are tblAlphaList and tblSchedule What I want the query to do is do some date math...