Multiple criteria in query causes errors in report

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?

--
Message posted via http://www.accessmonster.com

Nancy

We're not there. We can't see how you are trying to "enter in multiple days
of the week".

Please post the SQL statement of your query...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Nancy via AccessMonster.com" u57097@uwe wrote in message
news:a42a61bc4b9ab@uwe...
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?

--
Message posted via http://www.accessmonster.com

I place each number for the day of the week on separate lines
For every line you put a 'day of the week' you also have to put a
supervisor. If you do not then it figures you do not care and list them all.

--
Build a little, test a little.


"Nancy via AccessMonster.com" wrote:

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?

--
Message posted via http://www.accessmonster.com

.

Thanks so much Karl! That did it for me!

KARL DEWEY wrote:
I place each number for the day of the week on separate lines
For every line you put a 'day of the week' you also have to put a
supervisor. If you do not then it figures you do not care and list them all.

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
[quoted text clipped - 6 lines]
separate lines and I don't place quotations or anything else around them.
Could my problem lie there or could it be something else?

--
Message posted via http://www.accessmonster.com