expressions

  • Thread starter Thread starter Brent Rickels
  • Start date Start date
B

Brent Rickels

I'm importing data from a Unix database into Access. The
resulting table has numeric data in two fields. Field "G"
does not always have data in it, so it comes across with a
zero. In these cases, I want field "G" to contain the
same data that is in field "A". How can I do this?
 
Providing that you want to change EVERY 0 value in field [G], you could
create an Update Query. Set the criteria in field G to 0 and set the update
value to [F]. Save the query and run it.
 
Back
Top