GROUP on *either of two* fields 3

[JonBartels]

For each record in a table, either the *subtype1* field OR the *subtype2* field are populated, or else sometimes *neither field is populated*.
I want to group the records by "subtype" and get the data (when there is any) whether it is in either field.
How do I do this?
I am using Crystal Reports ver 8.
Thank you all for your help!

 

[dcm]

JonBartels: If you concatenate the 2 fields and group on that formula you'll get a response if either is populated. David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[kenhamady]

As long as you don't have nulls or spaces as the 'not populated' values. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[JonBartels]

thanks for the suggestion(s)
I appreciate your speedy reply!