selecting a given Day in a list of days under Frequency field(IN?)

B

babs

This is also on the forms- and have not gotten an answer need to know if at
all possible as soon as possible- Thanks

Thanks for your help I am still not seeming to explain what I need clearly

Right now I want to grab Today's DAY and pull up all records in the
query(criteria) with frequecy of doing all the jobs due today say- Wed .

I have in the criteria for the Frequency field =Format(Now(),"ddd"). It
does pull up ALL Wed ONLY frequency but want it to pull up if it says Mon,
Wed, Fri or Mon, Wed or any Combination.


Can I somehow use the In with what is already in the criteria row for the
frequecy field?
Doesn't seem to be working.

In("=Format(Now(),"ddd")" ) Tried # around the format code for both get
syntax error

any ideas?
Thanks,
Barb
 

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

want to grab Day of week in a LIST 2
pull up job due when needs to be done Once/month 1
top 5 days for each user 12
update query 0
Custom date format for days ... again ... thx <g> 10
Combine multiple records into one field in a Query 1
ASK Field Formatting 1
Printing recurring events first in a monthly layout 0

Top