return data between numbers

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

Guest

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
 
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.
 
Back
Top