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
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