Skip to Content
0
Former Member
Jan 06, 2012 at 03:33 PM

i think its a formula question (noob)

38 Views

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