Criteria in a query

  • Thread starter Thread starter Tonyaa
  • Start date Start date
T

Tonyaa

Hello all,

I have created a criteria in my query searching for records bille
within a certain month. My problem is that I'm trying to search onl
by month in a mm/dd/yy format, with the day being a wildcard character
For example, all invoices billed in 03/**/04 and I'm unable to come u
with results and I know for a fact that there are at least 50.

I also have a user prompted message in the criteria asking for th
date. I have [Enter Invoice Date].

Please advise because I am going crazy
 
I solved your problem two ways,

1. You mentioned that you have a prompt in the criteria to ask for th
date that will give you all that particular date in your data table.

2. if you put

Like "3/*/04" Or Like "3/*"

in your criteria it will work and yield all of March but it also give
every year in the table.

So I would opt on the first because it will give you just that month
date and year.

Much Succes
 
Back
Top