A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"NULL"



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2005, 05:00 PM
Tom magee via AccessMonster.com
external usenet poster
 
Posts: n/a
Default "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  
Old June 3rd, 2005, 07:43 PM
George Nicholson
external usenet poster
 
Posts: n/a
Default

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  
Old June 3rd, 2005, 08:28 PM
George Nicholson
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.