crteria Question

[karim]

Hello All,
I have a table with numbers in it. I need a button in the form to
open a report with a group of numbers. I tried "between [##] and [##]" in the
crteria but it ask me to put numbers to be shown in the rpt. Is there a way
to have to button when clicked to just view a certain group of numbers that I
would put in the crteria? like lets say I have in the table numbers from 1 to
1000. how can I get it to show me the range from 100 to 200 every time I
click the button with out asking about the range?

Thanks for all your help...

 

[karim]

Thanks all, I used this: >="BC0400" And <=" and it did what I wanted...