Access Query not returning desired records

[NaomiC]

Hi All,

I am trying to build a query that will return records that need to be deleted after 45 days.
My Notes column is set as a memo and these records have the text 45 DAY RULE(date) with other notations. How can I have my query return all records that are set to expire after 45 days or contain the text "45 DAY RULE"? For some reason it does not return any records at all.

My design looks like this:


And I want it to return this:

45 Day Rule
Date Requested	Last Name	First Name	Notes
11/29/2014	SMITH	JOHN	45 DAY RULE (1/13/15) Declined LNY on 11/25/14

Thank You!

[NaomiC]

Never mind! I was forgetting my asterisk in my criteria "*45 DAY RULE*"
It works now. Doh!

[pbaldy]

Thanks for following up with your solution, and welcome to the site!