You may need to use the conditional "IIF" function, something like this, in the RowSourse for the textfield:
=IIF([Fatality]=True,"Fatality",IIF([Injury]=True,"Injury: " & [InjuryDetails])) I hope I have the parentheses correctly matched here! Basically, the IIF statement goes like this: IIF([Boolean],"Value if true","Value if false"), and what I have done above is nesting another IIF for the [Fatality]=False part. Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of bassfolks Sent: Monday, September 05, 2005 12:44 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Report I want to put one field in a report reflecting information from several field. Fatality is a yes/no field; Injury is a yes/no field; Specifics of Injury is a text field. What I want in the report is where Fatality = yes, the word Fatality appears in the report field. If it is No, it does nothing and moves on to Injury. If Injury is yes, the word Injured appears in the report field followed by the details of the injury; if no, nothing is returned. I'm using Access 2003 and I'm sure it's simple, but I've been dinking with it for about an hour and haven't been able to get it to work properly. Thanks for your help! Debbie ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
