urgent help with filtering please

M

mhmaid

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.
 
S

Steve Schapel

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

Help creating a search form in Access XP 0
Summaries based on criteria 9
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
Counting Cells with Multiple Range Criteria (Excel 2003) 7
Dlookup 7
Content Control Box Issue - Please Help! 0

Top