I am a beginner crystal designer the company is not willing to train me on the software so poking my way through
How best should I do this?
The company I work for is requesting a report on people who do not have online accounts
Each person in the database has an account number section and a section that displays www if they have an online account. There are other info in the same section as the www like u201Cvruu201D u201Cdbtbu201D and others. Every time www, vru, or dbtb show as an individual data
Meaning:
Account # User name Agree Type
000232 Joe Smo vru
000232 Joe Smo dbtb
000232 Joe Smo www
000888 sue wall vru
000888 sue wall dbtb
000512 Jeff John vru
000512 Jeff John vru
000512 Jeff John www
What I want the report to display is only the accounts that do not have www like u201Csue wallu201D the other two accounts have www so I do not want to see them.
The result would only display:
000888 sue wall vru
000888 sue wall dbtb
My thinking of how to do a without report would be
If www shows up then do not display any information from that account number
But how do I do that. Thank you for any help