Combining fields from a record

[REDaughdril]

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

 

[DJBummy]

=[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).]