Day of the Week Query for more than one day

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

Guest

I have 2 tables, one with the field WeekDayId (autonumber) and DayOfWeek
(mon-fri). And one that uses the WeekDayId as the relationship field to the
first table.

I want to create a query that lets the user select a beginning day and an
ending day. The form that is based on this query would display the resulsts
as: Tues-Thurs
or just Tues if they only chose one day for both beginning and ending.

The closest I can come is this expression in my query:
Expr1: BeginDayOfWeek&'-'&EndDayOfWeek
But this gives me Tues-4

Can anyone help me?
 
Need a lot more information. Are BeginDayOfWeek and EndDayOfWeek fields in a
table? If so what table and what data type? Provide some sample data of what
would be in those fields.
 
Table 1: WeekDayID (autonumber) and DayOfWeek (Mon, Tues, Wed, etc)
Table 2: BeginDayOfWeek (Which is a combo box that lists the DayOfWeek data
from table 1 so the user can choose Mon, Tues, etc) and EndDayOfWeek (Which
is another combo box that lists the DayOfWeek data from table 1 so the user
can choose Mon, Tues, etc), and then other fields such as date, hours,
account number etc.
My users need to be able to choose several consecutive days and have it
display as (for example): Monday-Thursday, or an individual day displayed as
Monday.
It's for an absence report.
 
Back
Top