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
|
|||
|
|||
Pull info from another field if blank????
I have an invoice report that has customer billing information and customer
shipping information. If my shipping information is blank, how do I get the information from the billing information to be inserted into the shipping information fields as well as printing in the billing information fields? Thanks in advance. JR |
#2
|
|||
|
|||
If these are all in the same record, you can use Nz() in a control source
(or expression) like: =Nz([ShippingCity], [BillingCity]) -- Duane Hookom MS Access MVP "jwr" wrote in message ... I have an invoice report that has customer billing information and customer shipping information. If my shipping information is blank, how do I get the information from the billing information to be inserted into the shipping information fields as well as printing in the billing information fields? Thanks in advance. JR |
#3
|
|||
|
|||
Sorry for my ignorance, but I am not sure that I understand.
The bill to information is in one form created from a bill to table and the ship to information is in another form/table. Different records? Yes. How do I handle this situation? Thanks in advance, JR "Duane Hookom" wrote in message ... If these are all in the same record, you can use Nz() in a control source (or expression) like: =Nz([ShippingCity], [BillingCity]) -- Duane Hookom MS Access MVP "jwr" wrote in message ... I have an invoice report that has customer billing information and customer shipping information. If my shipping information is blank, how do I get the information from the billing information to be inserted into the shipping information fields as well as printing in the billing information fields? Thanks in advance. JR |
#4
|
|||
|
|||
Since we don't know anything about any relationship between tables (we
didn't even know there were two or more tables), we can't tell you how to pull any info. -- Duane Hookom MS Access MVP "jwr" wrote in message ... Sorry for my ignorance, but I am not sure that I understand. The bill to information is in one form created from a bill to table and the ship to information is in another form/table. Different records? Yes. How do I handle this situation? Thanks in advance, JR "Duane Hookom" wrote in message ... If these are all in the same record, you can use Nz() in a control source (or expression) like: =Nz([ShippingCity], [BillingCity]) -- Duane Hookom MS Access MVP "jwr" wrote in message ... I have an invoice report that has customer billing information and customer shipping information. If my shipping information is blank, how do I get the information from the billing information to be inserted into the shipping information fields as well as printing in the billing information fields? Thanks in advance. JR |
#5
|
|||
|
|||
I may not have made myself clear. Sorry.
I have a customer table containing billing information and a ship to table containing ship to info. These two tables are related via customer ID. "Duane Hookom" wrote in message ... Since we don't know anything about any relationship between tables (we didn't even know there were two or more tables), we can't tell you how to pull any info. -- Duane Hookom MS Access MVP "jwr" wrote in message ... Sorry for my ignorance, but I am not sure that I understand. The bill to information is in one form created from a bill to table and the ship to information is in another form/table. Different records? Yes. How do I handle this situation? Thanks in advance, JR "Duane Hookom" wrote in message ... If these are all in the same record, you can use Nz() in a control source (or expression) like: =Nz([ShippingCity], [BillingCity]) -- Duane Hookom MS Access MVP "jwr" wrote in message ... I have an invoice report that has customer billing information and customer shipping information. If my shipping information is blank, how do I get the information from the billing information to be inserted into the shipping information fields as well as printing in the billing information fields? Thanks in advance. JR |
#6
|
|||
|
|||
Can I assume you have both tables joined in the report's record source? If
so, the expression I provided should work. -- Duane Hookom MS Access MVP -- "jwr" wrote in message ... I may not have made myself clear. Sorry. I have a customer table containing billing information and a ship to table containing ship to info. These two tables are related via customer ID. "Duane Hookom" wrote in message ... Since we don't know anything about any relationship between tables (we didn't even know there were two or more tables), we can't tell you how to pull any info. -- Duane Hookom MS Access MVP "jwr" wrote in message ... Sorry for my ignorance, but I am not sure that I understand. The bill to information is in one form created from a bill to table and the ship to information is in another form/table. Different records? Yes. How do I handle this situation? Thanks in advance, JR "Duane Hookom" wrote in message ... If these are all in the same record, you can use Nz() in a control source (or expression) like: =Nz([ShippingCity], [BillingCity]) -- Duane Hookom MS Access MVP "jwr" wrote in message ... I have an invoice report that has customer billing information and customer shipping information. If my shipping information is blank, how do I get the information from the billing information to be inserted into the shipping information fields as well as printing in the billing information fields? Thanks in advance. JR |
#7
|
|||
|
|||
Thank you.
"Duane Hookom" wrote in message ... Can I assume you have both tables joined in the report's record source? If so, the expression I provided should work. -- Duane Hookom MS Access MVP -- "jwr" wrote in message ... I may not have made myself clear. Sorry. I have a customer table containing billing information and a ship to table containing ship to info. These two tables are related via customer ID. "Duane Hookom" wrote in message ... Since we don't know anything about any relationship between tables (we didn't even know there were two or more tables), we can't tell you how to pull any info. -- Duane Hookom MS Access MVP "jwr" wrote in message ... Sorry for my ignorance, but I am not sure that I understand. The bill to information is in one form created from a bill to table and the ship to information is in another form/table. Different records? Yes. How do I handle this situation? Thanks in advance, JR "Duane Hookom" wrote in message ... If these are all in the same record, you can use Nz() in a control source (or expression) like: =Nz([ShippingCity], [BillingCity]) -- Duane Hookom MS Access MVP "jwr" wrote in message ... I have an invoice report that has customer billing information and customer shipping information. If my shipping information is blank, how do I get the information from the billing information to be inserted into the shipping information fields as well as printing in the billing information fields? Thanks in advance. JR |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Memo Field | Sam | General Discussion | 12 | November 10th, 2005 09:16 PM |
How do i create blank enty in numeric field | scott munkirs | Running & Setting Up Queries | 2 | August 29th, 2005 09:51 PM |
How can I show all field data in a pivot table, instead of blank | Alastair Scott | General Discussion | 3 | August 17th, 2005 07:08 PM |
Select Query By Month. | Terry | Running & Setting Up Queries | 6 | June 2nd, 2005 04:10 PM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |