If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"NULL"
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
My bad. My veryyyyy bad.
I meant to say: =NZ([Apply-To],[InvoiceNumber]) -- George Nicholson Remove 'Junk' from return address. "George Nicholson" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I achieve this? | Jim Franklin | Using Forms | 5 | April 16th, 2005 11:57 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Need someone to look at SQL statement | Dkline | Running & Setting Up Queries | 4 | August 3rd, 2004 05:12 PM |
"UNION" Query with different fields in the two tables | Dkline | Running & Setting Up Queries | 5 | July 30th, 2004 09:05 PM |
Access inconsistencies | Hoopie | Running & Setting Up Queries | 2 | June 15th, 2004 10:53 AM |