Update Query

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I receive data in the form of a text file and transfer it to a table in
Access. The "Age" field contains a number from "1" to "15" but some records
contain "Over 16". I need to change the "Over 16" to "016" in order for it
to used in our system. Any help is greatly appreciated.


thanks
Tim
 
You can create a query from the table. Add all your
fields you want to the query. Create an Expression column
by typing NewAge: at the top of a column. Right-Click and
select Build or Zoom on NewAge:

Type this at the top of the column:

NewAge: iif([Age]="Over 16,"016",[Age])

You will have to link all your Forms/Reports to NewAge
instead of Age.

I hope this helps. Good luck.

Kevin11
 
Back
Top