Range of Records of update Query

P

ploddinggaltn

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
 
M

Marshall Barton

ploddinggaltn said:
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.
Click to expand...


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

Between 10 And 35
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Adding data to MS Access from csv file 0
Dynamic Naming of Form Button 3
Update query with date criteria 3
Update table to add new records 3
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Create update query for remaining records 10

Top