working with days of week

  • Thread starter Thread starter Afrosheen
  • Start date Start date
A

Afrosheen

I am in need of a routine where people working Monday - Fri. will not
display. Here is the senerio. I have some that work a day shift 5 days a
week. On the weekends of course they don't. In the database program I have to
input everyone that is working for that day. I don't want the ones working on
weekends displayed.

Any suggestions would be appreciated.
 
Afrosheen said:
I am in need of a routine where people working Monday - Fri. will not
display. Here is the senerio. I have some that work a day shift 5 days a
week. On the weekends of course they don't. In the database program I have
to
input everyone that is working for that day. I don't want the ones working
on
weekends displayed.

Any suggestions would be appreciated.
Click to expand...

Well, you don't say how your tables or your data are structured, but you can
certainly create a Query with a calculated field:

DayWorked: Weekday([datefield])

Using a criterion on this field of

BETWEEN 2 AND 6

will return only those records with Monday-Friday dates;

IN (1, 7)

will return weekend dates.
 
So which is it?

"I am in need of a routine where people working Monday - Fri. will not
display."

"I don't want the ones working on weekends displayed."
 
Hi and thanks for reading my post.
Here's the situation. I work at a job that is staffed 24/7/365. The support
staff only works Mon-Fri. The database I have has to keep track of all staff
at all times and where they're working in the building. So if the support
staff is not working on weekends or holidays then I need to have them set to
"day off". I just don't know how to do that. Setting a field to M-F may work
I don't know. That's why I'm looking for a routine to work with that.

Thanks again.

John W. Vinson/MVP said:
Afrosheen said:
I am in need of a routine where people working Monday - Fri. will not
display. Here is the senerio. I have some that work a day shift 5 days a
week. On the weekends of course they don't. In the database program I have
to
input everyone that is working for that day. I don't want the ones working
on
weekends displayed.

Any suggestions would be appreciated.
Click to expand...

Well, you don't say how your tables or your data are structured, but you can
certainly create a Query with a calculated field:

DayWorked: Weekday([datefield])

Using a criterion on this field of

BETWEEN 2 AND 6

will return only those records with Monday-Friday dates;

IN (1, 7)

will return weekend dates.
Click to expand...
 
Back
Top