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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for counting within specific constraints 2
Pivot table manual AUTOSORT 1
find and replace 2
Split data in field on character return 0
How to calculate work hours between two time/dates 12
Pivot table macro filter data between yesterday and today (date+time) 0
extracting numbers with no more than 8-digits using advanced filtering 10
Date as a number 2

Back
Top