S
Sammie
2 questions:
1. When concatenating a string on a report, how can I enter a carriage
return to start a new line? Or enough spaces to accomplish the same
thing? I would like a new line to start after "Ship's spares in
transit" and before [shipaddress] in the first half of my expression.
Here's my statement:
=IIf([ShipSparesInTransit]=-1,"SHIP'S SPARES IN TRANSIT" &
[ShipAddress],[ShipAddress])
2. How do I format the [ship date] field for a long date in this
expression:
=[ship date] & " via " & [carrier]
Thanks.
Sammie
1. When concatenating a string on a report, how can I enter a carriage
return to start a new line? Or enough spaces to accomplish the same
thing? I would like a new line to start after "Ship's spares in
transit" and before [shipaddress] in the first half of my expression.
Here's my statement:
=IIf([ShipSparesInTransit]=-1,"SHIP'S SPARES IN TRANSIT" &
[ShipAddress],[ShipAddress])
2. How do I format the [ship date] field for a long date in this
expression:
=[ship date] & " via " & [carrier]
Thanks.
Sammie