want to grab Day of week in a LIST

G

Guest

I have a frequency field and it is a drop down the choices are any
combination of days for example Mon, Wed, Fri or Mon, Tues or Wed or Wed,
Fri- you get what I mean- ANY combination. Each cleaning job that needs to
be done the frequency gets selected from the dropdown. That table is fine.

When I go to Completing the jobs. I would like to run a query that pulls up
all jobs for example due today(Wed).

When I put this Format(Now(),"ddd") in the criteria for Frequency ONLY
the jobs due on WED ONLY show up - would like ALL jobs where Wed is anywhere
in the frequency for example - Mon, Wed, Fri.

Am I explaining it okay.

Any ideas,
BArb
 
G

Guest

You should not put multiple data in a field. But that said, try this --
Like "*" & Format(Now(),"ddd") & "*"
 
G

Guest

It works!! thanks so much
Barb

KARL DEWEY said:
You should not put multiple data in a field. But that said, try this --
Like "*" & Format(Now(),"ddd") & "*"
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

selecting a given Day in a list of days under Frequency field(IN?) 2
pull up job due when needs to be done Once/month 1
Sorting day names chronologically 5
Day of week queries 4
scheduling cleaning jobs 1
Combine multiple records into one field in a Query 1
Listing activities by Week - Revisited 5
conditional running sum 7

Top