D
Dmackcwby
I'm in the proccess of creating a report that will provide information on
some of my employees but only the employees that I choose and I want this to
be on one report. I have created the query for the report and have used the
IN () expression to be able to choose the employees names. The IN ()
expression reads:
In ([Enter 1st CSR Name],[Enter 2nd CSR Name],[Enter 3rd CSR Name])
The query works fine and I know I'll be able to get the report work just
fine as well. However, I'm going to be setting up a form to input the
employess names from a combo box. I have done this before so I know it
works.
My question is, is there a way to set up the form to enter a null value?
Example: if I run just the query, I have to enter information in for each of
the request (CSR1, CSR2,CSR 3) even if I just hit the enter button. Is there
a way, to enter a null value into the query if I don't choose any thing from
the combo box on the form?
some of my employees but only the employees that I choose and I want this to
be on one report. I have created the query for the report and have used the
IN () expression to be able to choose the employees names. The IN ()
expression reads:
In ([Enter 1st CSR Name],[Enter 2nd CSR Name],[Enter 3rd CSR Name])
The query works fine and I know I'll be able to get the report work just
fine as well. However, I'm going to be setting up a form to input the
employess names from a combo box. I have done this before so I know it
works.
My question is, is there a way to set up the form to enter a null value?
Example: if I run just the query, I have to enter information in for each of
the request (CSR1, CSR2,CSR 3) even if I just hit the enter button. Is there
a way, to enter a null value into the query if I don't choose any thing from
the combo box on the form?