Just starting to teach myself Access so am very new to terminology and how things work, so please bear with me.
I have a table that records the number of days someone has off and want to create a query which will give me the number of days or greater specified in a form field. The form has other fields that can be used for a search which I have used Like criteria but when I try to use Like for the this particular field it won't give me a result I need. Below is the criteria I have used:
like"*"& (>=Forms![frmSearch]![#OfDays])&"*"
Could someone please explain what I have done wrong and how to fix it?
Thanks for any and all help.