User defined Like Parameter

  • Thread starter Thread starter dnewton
  • Start date Start date
D

dnewton

Is ther anyway I can tweak My query to let me specify what
recordsets I want displayed with the Like function.
Here is an example:
I have a table with the fields Name, Date, and Status
When I run the query, I want it to prompt me to enter the
name and a date range. The query will already have a
predifined Like argument for the status. Basically, I want
the name field, and the date field, to be user defined.
I got this query to run but it will not return any
records. Please help.
 
Is ther anyway I can tweak My query to let me specify what
recordsets I want displayed with the Like function.
Here is an example:
I have a table with the fields Name, Date, and Status
When I run the query, I want it to prompt me to enter the
name and a date range. The query will already have a
predifined Like argument for the status. Basically, I want
the name field, and the date field, to be user defined.
I got this query to run but it will not return any
records. Please help.
Click to expand...

I'd suggest renaming the Name and Date fields - these are both
reserved words. That said, you should be able to use a criterion on
[Name] and [Date] of

[Enter name:]
and
CDate([Enter date:])

respectively. If you've done so and still aren't getting the results
you want, please open the query in SQL view and post it here.
 
Back
Top