Hi forum! I hope you can help a newbie out on this one. I have a database with many tables, two of which I am using for this report. The table called IP.Minor_Code holds many codes for each Member of my company, but I am only interested in two codes: "CERTGREEN" and "ENVIRONF" for a report I am building that will show a list of Members, and whether they are "CERTGREEN" (Certified Green Lodging Hotel) or "ENVIRONF" (Environmentally Friendly), or both. I need each line of data to look like this:
Member Name | Address | #Rooms | CERT? | ENVIRONF?
The problem that I am having is that the select expert formula is looking for those two codes, CERTGREEN and ENVIRONF:
{ip_Major_Codes.major_code} = "A" and
{cli_Clients.ip_status} in ["MEMBER", "NONMEMIP"] and
{ip_Minor_Codes.Minor_Code} in ["CERTGREEN", "ENVIRONF"]
So, each Member record is showing twice. I need it to show only once, and if the member is CERTGREEN, then I need it to place a "Y" in the column under the CERT? heading, and if it's ENVIRONF, I need it to place a "Y" in the ENVIRONF? column. Better yet, rather than using "Y"s in each of those columns, if you can tell me how the heck I can tell it to put a check mark there instead, that would be phenomenal, and I would bow to the great formula guru who is YOU.
ANY SUGGESTIONS?
IP Logged
