N
Nydia
Hello all!!!
Let's see if I can explain this correctly.
I've created a database that will be used as a quick
reference to search for customers information regarding
job pleacement. It has 1 table and the table consist of
customer name and contact information (i.e. address,phone)
and his/her jobgoal (jobgoal=what type of job they are
looking for, ex. secretary).
The users will be searching by different criteria all the
time. May search for customer by zipcode 1x or by job goal
2x or by both. I don't want to create a new query for
each search, that would mean creating many queries. So I
was hoping that I could create 1 query with all the fields
and put in parameters for each field. This way they can
enter what ever criteria they have. the problem I am
having is that when i run the query and it prompts me to
enter information, if I don't have that information it
shows no records.
Example, I know that there are 2 customers with
jobgoal=secretary, but when the parameter prompts me for
job goal I enter secretary, when it prompts me to enter
information on the zipcode and i dont enter anything, the
query comes up with 0 clients when I know there should be
2 clients. Does this make sense, if so, what can i do to
fix this or will i have to make seperate queries for each
search (hope not) any help is greatly appreciated.
Nydia
..
Let's see if I can explain this correctly.
I've created a database that will be used as a quick
reference to search for customers information regarding
job pleacement. It has 1 table and the table consist of
customer name and contact information (i.e. address,phone)
and his/her jobgoal (jobgoal=what type of job they are
looking for, ex. secretary).
The users will be searching by different criteria all the
time. May search for customer by zipcode 1x or by job goal
2x or by both. I don't want to create a new query for
each search, that would mean creating many queries. So I
was hoping that I could create 1 query with all the fields
and put in parameters for each field. This way they can
enter what ever criteria they have. the problem I am
having is that when i run the query and it prompts me to
enter information, if I don't have that information it
shows no records.
Example, I know that there are 2 customers with
jobgoal=secretary, but when the parameter prompts me for
job goal I enter secretary, when it prompts me to enter
information on the zipcode and i dont enter anything, the
query comes up with 0 clients when I know there should be
2 clients. Does this make sense, if so, what can i do to
fix this or will i have to make seperate queries for each
search (hope not) any help is greatly appreciated.
Nydia
..