I have an update query and I want to update certain records. My table is
sorted ascenting and an example of records that I want to update are for the
range of:
050620122 to 112083505. This is a number in the first field that is sorted.
I can't remember what the "Between" phrase is.

>= 050620122 And <= 112083505

Having a leading zero suggests a text field so it could be

>= "050620122" And <= "112083505"


--
Regards,

OssieMac


"Beep Beep" wrote:

> I have an update query and I want to update certain records. My table is
> sorted ascenting and an example of records that I want to update are for the
> range of:
> 050620122 to 112083505. This is a number in the first field that is sorted.
> I can't remember what the "Between" phrase is.

OssieMac

Thanks

Perfect

"OssieMac" wrote:

>
> >= 050620122 And <= 112083505
>
> Having a leading zero suggests a text field so it could be
>
> >= "050620122" And <= "112083505"
>
>
> --
> Regards,
>
> OssieMac
>
>
> "Beep Beep" wrote:
>
> > I have an update query and I want to update certain records. My table is
> > sorted ascenting and an example of records that I want to update are for the
> > range of:
> > 050620122 to 112083505. This is a number in the first field that is sorted.
> > I can't remember what the "Between" phrase is.