"NULL"

  • Thread starter Thread starter Tom magee via AccessMonster.com
  • Start date Start date
T

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.
 
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,
 
My bad. My veryyyyy bad.

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

--
George Nicholson

Remove 'Junk' from return address.


George Nicholson said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top