Using * character (NOT wildcard) in a parameter query

[focosi]

I am forced to use the "*" character in the criteria field of a parameter query.


Criteria looks like : [Forms]![Patients].[Last name] & "*" & [Forms]![Patients].[First name]

Just to retrieve values like "CLINTON*BILL"

Can someone suggest right syntax plz ?? I have alrady tried unsuccessfully :

[Forms]![Patients].[Last name] & '*' & [Forms]![Patients].[First name]
[Forms]![Patients].[Last name] & "'*'" & [Forms]![Patients].[First name]
[Forms]![Patients].[Last name] & '"*"' & [Forms]![Patients].[First name]

And not, the syntax of the field cannot be changed because it relies on another database I cannot modify...
PLZ HELP!!

[orange]

Try using [*] ---square bracket around the asterisk

eg

[Forms]![Patients].[Last name] & "[*]" & [Forms]![Patients].[First name]

[focosi]

didn't work (caused an input box asking for [*] field value)...
Other hints?

[June7]

Don't understand what you are trying to do. Why is this necessary? What would be between CLINTON and BILL that needs to be wildcarded?

[orange]

What is stored in the underlying table?
Please show the query sql.

I have attached a jpg showing a Form and a query based on a value in that form

Name & "*" & id

and it displays the result. I think we have to look closer at your query and parameter.

[orange]

June,
I don't think he's trying to wildcard anything. I think he is trying to get output with an asterisk between first and last name,
But I agree it isn't clear. I'd like to see the parameter query in SQL format.

It's possible he has not told us everything.

[focosi]

orange, you understood correctly my questions.
And sorry, [Forms]![Patients].[Last name] & "*" & [Forms]![Patients].[First name] was the right syntax, I just had wrong values in the field. Everything was ok. Sorry for boring you. Thank you for your prompt feedback!