Query doesn't recognize criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am wanting to build a query based on criteria where the field in the table is formatted for text. The text in the fields are basically month/year, i.e., 11/03, 12/03..etc. If I enter "12/03" in the criteria box, the query will not return anything. Any help is appreciated.
 
I think you will find the format is applied to the resultset, and you are
tring to filter by that formatted value.

Jim said:
I am wanting to build a query based on criteria where the field in the
Click to expand...
table is formatted for text. The text in the fields are basically
month/year, i.e., 11/03, 12/03..etc. If I enter "12/03" in the criteria box,
the query will not return anything. Any help is appreciated.
 
What I did to correct the problem was to take out the slash between the month and year numbers. Not a very clean way to get it, but it did work. The table has a field called Date, that is formatted as text, because I couldn't get Access to work for me with just the month and year as the date format. The query was searching the Date field for what I was entering into the criteria field. I'm not too clear on what you were saying about the resultset. If possible, could you elaborate? Thanks.
 
Back
Top