Query or Form for criteria between . . .

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

Guest

I need to I need to set up a mailing list with criteria such as: 541101 -
541105. Is it possible to do this? I've been working on this for a while!

If it is not possible I'll have to filter each criteria # individually and I
have many.

Thanks for any help.
 
I need to I need to set up a mailing list with criteria such as: 541101 -
541105. Is it possible to do this? I've been working on this for a while!

If it is not possible I'll have to filter each criteria # individually and I
have many.

Thanks for any help.
Click to expand...

Sure.

BETWEEN 541101 AND 541105

or, better

BETWEEN [Enter start number:] AND [Enter end number:]

or, even better yet, create a little form named frmCrit with two
textboxes txtFrom and txtTo and use

BETWEEN [Forms]!{frmCrit]![txtFrom] AND [Forms]![frmCrit]![txtTo]

Put a command button on frmCrit to launch your Report, or mail merge,
or EMail blast, or whatever kind of mailing you're doing.

John W. Vinson[MVP]
 
Between 541101 And 541105

.... or, if the field is a text rather than a numeric field ...

Between "541101" And "541105"
 
Back
Top