Using wildcards

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I am writing a number of reports based on queries and want to use wildcards
eg If I want a report which gives me all my records where eg the Document
Name (which is a control) includes " Consumer Cre%" where % is the
wildcard. I have a user entry box that asks for the parameter of the query
in other words when they run the report a parameter box will ask for the
document name and this is where they will put things like "Consumer Cre%" Is
this possible?
As always
TIA
Tony Williams
 
Thanks Duane I'll try that
Tony
Duane Hookom said:
Sure, however in Access/Jet queries, you use "*" as the wildcard.

--
Duane Hookom
MS Access MVP


Cre%"
Click to expand...
 
Duane I have a problem The user wants forms not reports. So I have created a
form based on my query and the user opens it with a prompt form that asks
for the Document name and start date and end date. The control for document
name on my prompt form is finddocnametxt and the parameter in the query is
[forms]![frmFindDocumentName]![finddocnametxt]
this parameter is in the control in the query called Docnametxt which is the
data I'm trying to find. But I don't get any records. Any ideas where I'm
going wrong?
TIA
Tony
 
Sorry Duane I think I've cracked it I've used Like in the parameter and that
seems to work
Tony
 
Back
Top