Using a Query Parameter with the "like" SQL operator

[jdaubens]

I have the need to select the records in a query based on the last 4 digets in a text field that are equal to a specified value. I created a Query with a parameter as follows:

Parameter Data Type
[Enter Report Year] Text

Then in my Criteria row for the field in the query I specified:

Like "[*Enter Report Year]"

This does not work. Does anyone have any suggestions??

Thanks

 

[LarryDeLaruelle]

I believe the format should be Like "*" & [Prompt]

Not sure if that is exact.

Larry De Laruelle
larry1de@yahoo.com

 

[jdaubens]

It worked! Thanks. Do you have any pointers on how to set up the Criteria to select all of the dates from a field with a date data type that belong to a certain month or certain year?

Thanks again

 

[TheInsider]

Hi,
In the query design view, set the Field source to Month([MyDateField]) or Year([MyDateField]) , then in the Criteria field assign the appropriate value. For example, if you want all dates in the month of October, put a 10 for the criteria.

Rob Marriott
rob@career-connections.net

 

[jdaubens]

That worked real well. Thanks for your help.