Pull info from another field if blank????

[jwr]

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

 

[Duane Hookom]

If these are all in the same record, you can use Nz() in a control source
(or expression) like:
=Nz([ShippingCity], [BillingCity])

 

[jwr]

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

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

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

 

[Duane Hookom]

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

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

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

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

 

[jwr]

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.

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

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

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


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

 

[Duane Hookom]

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
--

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.

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

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
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


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

 

[jwr]

Thank you.

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
--

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.

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


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
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


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