Exclude records based on the day of the week name (e.g. Monday)

[Silvio]

Objective: Employees that are scheduled to be off today should be excluded
from the list of available.

I have 1 table with 2 text fields EmployeeName and DayOff. The DayOff field
has one of the days of the week in it (e.g. Monday). I managed to extract the
name of the day of the week fro today’s date, however I am having trouble to
compare the two field in the query in order to exclude record where the name
in the two filed are equal (DayOff<>DayWeek).

This is what I have:
SELECT tblEmployees.Name, tblEmployees.DayOff, Format(Date(),"dddd") AS
DayWeek
FROM tblEmployees;

Thank you folks.

 

[Jeff Boyce]

It sounds like you want to see the Employee where DayOff is <> Today's "Day
of the Week".

Your SQL statement has no WHERE clause.

Your SQL statement has no way to determine Today's "Day of the Week" for
comparison purposes.

Have you tried using the query design view to do this, rather than in SQL?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Silvio]

I did but it does not work.

It sounds like you want to see the Employee where DayOff is <> Today's "Day
of the Week".

Your SQL statement has no WHERE clause.

Your SQL statement has no way to determine Today's "Day of the Week" for
comparison purposes.

Have you tried using the query design view to do this, rather than in SQL?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Try this --
SELECT tblEmployees.Name, tblEmployees.DayOff, Format(Date(),"dddd") AS
DayWeek
FROM tblEmployees
WHERE tblEmployees.DayOff <> Format(Date(),"dddd");

 

[Silvio]

Karl, thanks a lot this works just fine.

Try this --
SELECT tblEmployees.Name, tblEmployees.DayOff, Format(Date(),"dddd") AS
DayWeek
FROM tblEmployees
WHERE tblEmployees.DayOff <> Format(Date(),"dddd");

 

[John W. Vinson]

Objective: Employees that are scheduled to be off today should be excluded
from the list of available.

I have 1 table with 2 text fields EmployeeName and DayOff. The DayOff field
has one of the days of the week in it (e.g. Monday). I managed to extract the
name of the day of the week fro today’s date, however I am having trouble to
compare the two field in the query in order to exclude record where the name
in the two filed are equal (DayOff<>DayWeek).

It might be simpler if your DayOff field were an integer, 1 (Sunday) through 7
(Saturday), though you can use the name of the day if you prefer. I take it
employees only get one day off a week? Never two? (Wouldn't want to work
there!!!)

That said...

SELECT tblEmployees.Name
FROM tblEmployees
WHERE tblEmployees.DayOff <> Format(Date()), "dddd");

 

[Jeff Boyce]

"does not work" doesn't give us much to go on.

The query design view works just fine for my queries ... what's it doing on
yours?

Regards

Jeff Boyce
Microsoft Office/Access MVP