Range of Records of update Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ploddinggaltn - 20 Apr 2008 17:38 GMT

I'm stuggling with how to list a range of record numbers for an update query
in the criteria field. I'm trying to update the VehID to "1" for records 10
- 35 in the TravelerID field. I have the upate query and have 1 in the VehID
"Update To" filed but having trouble with how to format the range of record
numbers in the Criteria area. Your help is greatly appreciated, thank you

Reply to this Message

Marshall Barton - 20 Apr 2008 18:43 GMT

>I'm stuggling with how to list a range of record numbers for an update query
>in the criteria field. I'm trying to update the VehID to "1" for records 10
>- 35 in the TravelerID field. I have the upate query and have 1 in the VehID
>"Update To" filed but having trouble with how to format the range of record
>numbers in the Criteria area.

I think all you need for TravelerID's Criteria is:

Between 10 And 35

Signature

Marsh
MVP [MS Access]

Reply to this Message