"NULL"

[Tom magee via AccessMonster.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.

 

[George Nicholson]

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]

My bad. My veryyyyy bad.

I meant to say:
=NZ([Apply-To],[InvoiceNumber])

--
George Nicholson

Remove 'Junk' from return address.

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.

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.