return data between numbers

  • Thread starter lost in a wildcard query
  • Start date
L

lost in a wildcard query

i have a data base that has data in a field showing 200101 to 200710
i need to pull data between 200101 and 200112, then 200201 and 200212 ., etc.

I have tried between but to no avail
 
K

KARL DEWEY

Is your field with 200101 a text or number field? Do you want to total some
other fields so as to rollup data by the year? Post your table structure -
field names and data type.
 
Top