Can Access pick between two addresses?

[DSmith]

In a report, can I pick between a home or office address to print based on
Send To field of O or H?

 

[Duane Hookom]

Yes, you can probably use an expression in a control source like:
=IIf([SendTo]="O",[AddressOffice], [AddressHome])

 

[DSmith]

If the office and home address are several fields, do I just put it into one
expression such as: =([FirstName] & " " & [LastName]) & Chr(13) & Chr(10) &
[Address] & [Address2] & Chr(13) & Chr(10) & [City] & "," & [State] & " " &
[zipcode])

Yes, you can probably use an expression in a control source like:
=IIf([SendTo]="O",[AddressOffice], [AddressHome])

--
Duane Hookom
MS Access MVP
--

In a report, can I pick between a home or office address to print based on
Send To field of O or H?

 

[Duane Hookom]

Probably... try it. I don't know how many copies of the fields you have in
your table.

--
Duane Hookom
MS Access MVP
--

If the office and home address are several fields, do I just put it into
one
expression such as: =([FirstName] & " " & [LastName]) & Chr(13) & Chr(10)
&
[Address] & [Address2] & Chr(13) & Chr(10) & [City] & "," & [State] & " "
&
[zipcode])

Yes, you can probably use an expression in a control source like:
=IIf([SendTo]="O",[AddressOffice], [AddressHome])

--
Duane Hookom
MS Access MVP
--

In a report, can I pick between a home or office address to print based on
Send To field of O or H?

 

[DSmith]

It didn't work with the one line. So I'm doing one field at a time and that
works --just cumbersome.

Probably... try it. I don't know how many copies of the fields you have in
your table.

--
Duane Hookom
MS Access MVP
--

If the office and home address are several fields, do I just put it into
one
expression such as: =([FirstName] & " " & [LastName]) & Chr(13) & Chr(10)
&
[Address] & [Address2] & Chr(13) & Chr(10) & [City] & "," & [State] & " "
&
[zipcode])

Yes, you can probably use an expression in a control source like:
=IIf([SendTo]="O",[AddressOffice], [AddressHome])

based
on

Send To field of O or H?

 

[DSmith]

OK- the one line did work after minor adjustments-worked great! Thanks a
lot!

It didn't work with the one line. So I'm doing one field at a time and that
works --just cumbersome.

Probably... try it. I don't know how many copies of the fields you have in
your table.

--
Duane Hookom
MS Access MVP
--

If the office and home address are several fields, do I just put it into
one
expression such as: =([FirstName] & " " & [LastName]) & Chr(13) & Chr(10)
&
[Address] & [Address2] & Chr(13) & Chr(10) & [City] & "," & [State] &

"

"

&
[zipcode])

Yes, you can probably use an expression in a control source like:
=IIf([SendTo]="O",[AddressOffice], [AddressHome])

--
Duane Hookom
MS Access MVP
--

In a report, can I pick between a home or office address to print based
on
Send To field of O or H?