B
babs
I have a list of jobs in a jobs table and it list which days the jobs need to
be done. For example some are just M, some M, W, F , some just W etc.
I am trying to grab the current date on the Form ( an unbound field where I
use datepart to grab the current DAY
I have created a query for the jobs list and would like for the criteria to
pull up all jobs say due on Wednesday. I can put the criteria in as Like
"*w*" and get what I want. However I would like for it to know that it is
wednesday(or whatever the CURRENT DAY is) and grab it from the form(or just
from the query-whatever would work) and use this field in the Query Criteria.
What am I missing?? How do I write the criteria in the query.
Thanks,
Barb
be done. For example some are just M, some M, W, F , some just W etc.
I am trying to grab the current date on the Form ( an unbound field where I
use datepart to grab the current DAY
I have created a query for the jobs list and would like for the criteria to
pull up all jobs say due on Wednesday. I can put the criteria in as Like
"*w*" and get what I want. However I would like for it to know that it is
wednesday(or whatever the CURRENT DAY is) and grab it from the form(or just
from the query-whatever would work) and use this field in the Query Criteria.
What am I missing?? How do I write the criteria in the query.
Thanks,
Barb