Append Query (with if/then)

  • Thread starter FJC via AccessMonster.com
  • Start date
F

FJC via AccessMonster.com

Hi,
I'm trying to the get field information from an old table into a new table
that is already populated with company information. I want to say: if the
company = thecompanyname then add this field to the record. Anyway of doing
that?

Thanks.
 
G

ghetto_banjo

When you say "add this field to the record", do you mean "Update that
field in the record"?
 
Top