Combining fields from a record

REDaughdril

Registered User.
Local time
Today, 14:15
Joined
Jan 23, 2000
Messages
58
How do I combine fields from one recored to make a sentence.

Owner|Color|Sex |Animal|Pet's Name|
-------------------------------------
Jane |Black|Female|Cat |FiFi |
John |Red |Male |Dog |Spot |

In a report to come out as
Jane's Black Female Cat name is FiFi (or)
John's Red Male Dog name is Spot

Thanks for the help!!!
 
=[Owner]&"'s " &[Color]&" "&[Sex]&" "&[Animal]&" name is " &[Pet's Name]
The quotes are to put spaces between the fields.
put in unbound text box. in control source.

D.J.

[This message has been edited by DJBummy (edited 08-27-2001).]
 

Users who are viewing this thread

Back
Top Bottom