HELP! adding parameter to a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help!

I'm trying to add a parameter to a query, and it's not working. I want
enter the market that I'm searching for, and have it return how many records
match the query. I have to put asterisks before and after the market because
there are sometimes more than one market listed. So far, I have:

Example: auda adag alla allw

[Enter Market:] & "*"

What am I doing wrong? It returns 0 records every time, and I need to get
this fixed today.
 
What are you entering in the parameter when prompted ?
I think all you may have to do is change it to

Like [Enter Market:] & "*"
 
...which will work if it is the first market in the list. I think it should
be Like "*" & [Enter Market:] & "*", however , can you confirm in your
example that "auda adag alla allw" is either what you type in when prompted,
or the contents of a field?

My hunch is the latter. I've got to point out that you have the problems as
you are trying to store multiple values in a single field. RDBMS' are not
designed to work like that.





Dennis said:
What are you entering in the parameter when prompted ?
I think all you may have to do is change it to

Like [Enter Market:] & "*"

Ryan Proudfit said:
Please help!

I'm trying to add a parameter to a query, and it's not working. I want
enter the market that I'm searching for, and have it return how many
records
match the query. I have to put asterisks before and after the market
because
there are sometimes more than one market listed. So far, I have:

Example: auda adag alla allw

[Enter Market:] & "*"

What am I doing wrong? It returns 0 records every time, and I need to
get
this fixed today.
Click to expand...
Click to expand...
 
Thanks alot!

Dennis said:
What are you entering in the parameter when prompted ?
I think all you may have to do is change it to

Like [Enter Market:] & "*"

Ryan Proudfit said:
Please help!

I'm trying to add a parameter to a query, and it's not working. I want
enter the market that I'm searching for, and have it return how many records
match the query. I have to put asterisks before and after the market because
there are sometimes more than one market listed. So far, I have:

Example: auda adag alla allw

[Enter Market:] & "*"

What am I doing wrong? It returns 0 records every time, and I need to get
this fixed today.
Click to expand...
Click to expand...
 
Back
Top