Parameter Query returns no records

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

Guest

I created a select query to pull the records from a table. The query pull all
of the fields, including an autonumber field. When I run the select query,
all of the fields and records are returns.

I then created a parameter for this query. The parameter was in the Taxpayer
Name field, using the criteria [What Taxpayer Name do you want?]. When I run
the query again, the criteria dialog opens and I enter the taxpayer. The
query returns no records. I tried using CAPS LOCK on, off and with and
without the wildcard *. The query is set to look in anypart of the field.

I also tried the method suggested by Duane Hookum
(http://www.fontstuff.com/access/acctut08.htm). Same result. No records
returned.
What am I missing? The end purpose is to call up a sprecific record and then
print the related form.

Thank you.
 
It's hard to say without seeing the SQL you have.

The wild card you used in the query look like that?

Select * From TableName Where FieldName Like "*" & [What Taxpayer Name do
you want?] & "*"
 
No. The wildcard was entered into the dialog box on the parameter query box -
ACCURATE*.

The parameter query was built with the Design View option in Query - New.
People accuse me of mangling English so you can imagine how bad I am at
Structured Query Language.
--
I know enuff to be dangerous.


Ofer Cohen said:
It's hard to say without seeing the SQL you have.

The wild card you used in the query look like that?

Select * From TableName Where FieldName Like "*" & [What Taxpayer Name do
you want?] & "*"


--
Good Luck
BS"D


RealGomer said:
I created a select query to pull the records from a table. The query pull all
of the fields, including an autonumber field. When I run the select query,
all of the fields and records are returns.

I then created a parameter for this query. The parameter was in the Taxpayer
Name field, using the criteria [What Taxpayer Name do you want?]. When I run
the query again, the criteria dialog opens and I enter the taxpayer. The
query returns no records. I tried using CAPS LOCK on, off and with and
without the wildcard *. The query is set to look in anypart of the field.

I also tried the method suggested by Duane Hookum
(http://www.fontstuff.com/access/acctut08.htm). Same result. No records
returned.
What am I missing? The end purpose is to call up a sprecific record and then
print the related form.

Thank you.
Click to expand...
Click to expand...
 
The wild card need to be outside the dialog box, as I should you in the
previous post, other wisr it will treat the * as a part of the string, and
this is why you get no resault

In the criteria of the field write

Like "*" & [What Taxpayer Name do you want?] & "*"

--
Good Luck
BS"D


RealGomer said:
No. The wildcard was entered into the dialog box on the parameter query box -
ACCURATE*.

The parameter query was built with the Design View option in Query - New.
People accuse me of mangling English so you can imagine how bad I am at
Structured Query Language.
--
I know enuff to be dangerous.


Ofer Cohen said:
It's hard to say without seeing the SQL you have.

The wild card you used in the query look like that?

Select * From TableName Where FieldName Like "*" & [What Taxpayer Name do
you want?] & "*"


--
Good Luck
BS"D


RealGomer said:
I created a select query to pull the records from a table. The query pull all
of the fields, including an autonumber field. When I run the select query,
all of the fields and records are returns.

I then created a parameter for this query. The parameter was in the Taxpayer
Name field, using the criteria [What Taxpayer Name do you want?]. When I run
the query again, the criteria dialog opens and I enter the taxpayer. The
query returns no records. I tried using CAPS LOCK on, off and with and
without the wildcard *. The query is set to look in anypart of the field.

I also tried the method suggested by Duane Hookum
(http://www.fontstuff.com/access/acctut08.htm). Same result. No records
returned.
What am I missing? The end purpose is to call up a sprecific record and then
print the related form.

Thank you.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top