Update Query Question

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I have a table with a field named "CaseType". When a
record is entered into the table, the casetype is manually
assigned. I need to create a form to change
the "CaseType" for individual records when the incorrect
CaseType is entered. I need to create a select query to
bring up the speciifc record, then change the case type
for just that individual record. What criteria do I use
in my select query to ask for the specific record number.
Your help is appriciated, thank you
 
What criteria do I use
in my select query to ask for the specific record number.
Click to expand...

Do you have a "record number" field in your table? If not you are out
of luck: a table is an unordered "bag" of data and the records do not
HAVE record numbers.
 
Back
Top