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 “vru” “dbtb” 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 “sue wall” 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
Edited by shallowz - 06 Jan 2012 at 4:32am