update queries

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

Guest

i have an update query and i want to update a lookup field. how can i select the data/value instead of typing it? because if i type it the value does not become updated when i change the value in the lookup source

moreover i encounter problems with the criteria i am trying to set in another field. the records are numbers and i want to select for example a record that is equal to number 5 and the records that are between 100 and 150 and between 312 and 314. could you give me a hint on how to build the criteria?

thank you in advance for your help!
 
The first paragraph needs more description. Please break down to smaller
pieces.

The 2nd PP:
SELECT *
FROM tablename
WHERE
field = 5 OR
field Between 100 And 150 OR
field Between 312 and 314


--
Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.fmsinc.com/consulting/

angie said:
i have an update query and i want to update a lookup field. how can i
Click to expand...
select the data/value instead of typing it? because if i type it the value
does not become updated when i change the value in the lookup source.
moreover i encounter problems with the criteria i am trying to set in
Click to expand...
another field. the records are numbers and i want to select for example a
record that is equal to number 5 and the records that are between 100 and
150 and between 312 and 314. could you give me a hint on how to build the
criteria?
 
in the update query i want to fill in the "update to" in a particular field with a value

i fill in the value and i get the results i want successfully

the field, however, is a lookup field (i select with a combo box the value from a query when i open the table
and it would save me time if i could salect the value in the update query too instead of typing it

i hope i 've stated the problem more clearly now
 
Back
Top