Parameter Qeury won't populate

[Guest]

Good afternoon,

I am using a parameter query w/ first name and last name prompts to search
for records. (I placed the parameter criteria on 2 different lines to
similate an OR statement rather than on same line to simulate an AND
statement). I put [Enter First Name:] in criteria for First Name field, and
[Enter Last Name:] in next line down on Last Name field. I have a fake record
listed for testing purposes that has "Mr." as first name and "Man" for last
name. I also have a record w/ "Miss" as first name.

In my parameter query, if I fully type "Mr." in First name prompt, or skip
that prompt and type "Man" in last name prompt, either of these will bring up
my sample record. Now my understanding is if I leave these prompts blank, it
should bring up all records, e.g. "Mr." record and "Miss" record. But nothing
comes up and my query has no records. I also thought I could use a wild card
like M* and that should bring up all records w/ name beginning w/ "M". Is
this not correct? What's wrong w/ my query? Thanks

 

[Rick B]

No.

To allow partials, change your criteria to...
Like "*" & [Enter First Name:] & "*"


And...
Like "*" & [Enter Last Name:] & "*"

 

[Guest]

Great Thanks. I'll try that, but why aren't any records appearing if I leave
prompt blank? Shouldn't that default to all records? Thanks

No.

To allow partials, change your criteria to...
Like "*" & [Enter First Name:] & "*"


And...
Like "*" & [Enter Last Name:] & "*"



--
Rick B

Good afternoon,

I am using a parameter query w/ first name and last name prompts to search
for records. (I placed the parameter criteria on 2 different lines to
similate an OR statement rather than on same line to simulate an AND
statement). I put [Enter First Name:] in criteria for First Name field, and
[Enter Last Name:] in next line down on Last Name field. I have a fake record
listed for testing purposes that has "Mr." as first name and "Man" for last
name. I also have a record w/ "Miss" as first name.

In my parameter query, if I fully type "Mr." in First name prompt, or skip
that prompt and type "Man" in last name prompt, either of these will bring up
my sample record. Now my understanding is if I leave these prompts blank, it
should bring up all records, e.g. "Mr." record and "Miss" record. But nothing
comes up and my query has no records. I also thought I could use a wild card
like M* and that should bring up all records w/ name beginning w/ "M". Is
this not correct? What's wrong w/ my query? Thanks

 

[Rick B]

No not using your current code. You are telling it that the field must be =
blank.

Once you change the criteria to what I gave you, then blanks will work.


--
Rick B

Great Thanks. I'll try that, but why aren't any records appearing if I leave
prompt blank? Shouldn't that default to all records? Thanks

No.

To allow partials, change your criteria to...
Like "*" & [Enter First Name:] & "*"


And...
Like "*" & [Enter Last Name:] & "*"



--
Rick B

Good afternoon,

I am using a parameter query w/ first name and last name prompts to search
for records. (I placed the parameter criteria on 2 different lines to
similate an OR statement rather than on same line to simulate an AND
statement). I put [Enter First Name:] in criteria for First Name

field,
and

[Enter Last Name:] in next line down on Last Name field. I have a fake record
listed for testing purposes that has "Mr." as first name and "Man" for last
name. I also have a record w/ "Miss" as first name.

In my parameter query, if I fully type "Mr." in First name prompt, or skip
that prompt and type "Man" in last name prompt, either of these will

bring
up

my sample record. Now my understanding is if I leave these prompts

blank,
it

should bring up all records, e.g. "Mr." record and "Miss" record. But nothing
comes up and my query has no records. I also thought I could use a

wild
card

like M* and that should bring up all records w/ name beginning w/ "M". Is
this not correct? What's wrong w/ my query? Thanks

 

[Guest]

Cool. I didn't know that. Thanks.

No not using your current code. You are telling it that the field must be =
blank.

Once you change the criteria to what I gave you, then blanks will work.


--
Rick B

Great Thanks. I'll try that, but why aren't any records appearing if I leave
prompt blank? Shouldn't that default to all records? Thanks

No.

To allow partials, change your criteria to...
Like "*" & [Enter First Name:] & "*"


And...
Like "*" & [Enter Last Name:] & "*"



--
Rick B



Good afternoon,

I am using a parameter query w/ first name and last name prompts to search
for records. (I placed the parameter criteria on 2 different lines to
similate an OR statement rather than on same line to simulate an AND
statement). I put [Enter First Name:] in criteria for First Name field,
and
[Enter Last Name:] in next line down on Last Name field. I have a fake
record
listed for testing purposes that has "Mr." as first name and "Man" for
last
name. I also have a record w/ "Miss" as first name.

In my parameter query, if I fully type "Mr." in First name prompt, or skip
that prompt and type "Man" in last name prompt, either of these will bring
up
my sample record. Now my understanding is if I leave these prompts blank,
it
should bring up all records, e.g. "Mr." record and "Miss" record. But
nothing
comes up and my query has no records. I also thought I could use a wild
card
like M* and that should bring up all records w/ name beginning w/ "M". Is
this not correct? What's wrong w/ my query? Thanks