Parameter Query returns no records

[RealGomer]

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.

 

[Ofer Cohen]

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?] & "*"

 

[RealGomer]

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.

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

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.

 

[Ofer Cohen]

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

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.

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

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.