urgent help with filtering please

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

Guest

I want to create a macro to filter by range I.E (FROM NO 05-01-000 TO
05-01-999) what should i put in the "where condition"
MY CONTROL NAME IS PAGENO.
 
Mhmaid,

It is not clear what sort of a macro you are talking about here, or what
you are trying to do. But I think this might work...
WHERE [PAGENO] Like "05-01*"
 

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

Use Macro to Filter records in Subform on open 0
Combine two sets of overlapping Date/Time data into 3 columns. 3
Currect syntax for ApplyFilter command in Subform 1
compare dates with different formats 2
Counting Cells with Multiple Range Criteria (Excel 2003) 7
filter error 1
Help with Excel 2007 COUNTIFS! 0
open report with double filter 1

Back
Top