Get report based on zipcodes

Hello,

I need a query where I can give a beginning zipcode and ending
zipcode. These zipcodes include some with zip+4. I know to use the
between function. Please help.

Robert

Re: Get report based on zipcodes

"Robert" wrote in message
news:1192461376.619503.167200@v23g2000prn.googlegroups.com.. .
> Hello,
>
> I need a query where I can give a beginning zipcode and ending
> zipcode. These zipcodes include some with zip+4. I know to use the
> between function. Please help.
>
> Robert

caution - air code - watch line wrap

Select * From tblData Where Cint(Left([ZipCode],5)) Between [Enter Zip1] And
[Enter Zip2]

Fred Zuckerman