Create an update query. Add your "Apply-To" field. Under "UpdateTo":
=NZ([Apply-To],[Apply-To],[InvoiceNumber])

Translation: If Apply-To is Null, use InvoiceNumber instead, otherwise use
the existing Apply-To value.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Tom magee via AccessMonster.com" wrote in
message news:cbba3bf363ad400ca6e5cfa96e7a2ad4@AccessMonste r.com...
We get a file from a 3rd party where a field is populated with an invoice
reference number or Null.

I have one table where I have both credit-memos and invoice details.

The field where the Null appears (relating to a credit memo) refers to an
invoice number

The invoice records have Null because the invoice number is held in
"Invoice Number"

I want to have the null replaced with the contents of another field...like
an IF statement I guess.

Can anyone help?




Tom



What am i upto ? Matching invoice numbers and credit memos.

--
Message posted via http://www.accessmonster.com