N
Nancy via AccessMonster.com
I am running a weekly management efficiency report that is based on a query.
In that query I specify the supervisor's name, the week end date and the day
of the week (which is a number 1 through 6). This works fine when I enter in
one supervisor's name, one week end date and one day of the week. However,
when I try to enter in multiple days of the week I run into problems. Even
though I specify only one supervisor, when I place more than one day of the
week in the criteria field, the query returns with multiple supervisors. I'm
not sure what is causing this. I place each number for the day of the week on
separate lines and I don't place quotations or anything else around them.
Could my problem lie there or could it be something else?
In that query I specify the supervisor's name, the week end date and the day
of the week (which is a number 1 through 6). This works fine when I enter in
one supervisor's name, one week end date and one day of the week. However,
when I try to enter in multiple days of the week I run into problems. Even
though I specify only one supervisor, when I place more than one day of the
week in the criteria field, the query returns with multiple supervisors. I'm
not sure what is causing this. I place each number for the day of the week on
separate lines and I don't place quotations or anything else around them.
Could my problem lie there or could it be something else?