Joined: 10 Sep 2009
Location: United States
Online Status: Offline
Posts: 9
Topic: Show records outside of critera Posted: 02 Oct 2009 at 12:39pm
In my database, I have docket numbers. For each docket number, there may be several charges. On each charge screen there is a charge status code.
What I am trying to do is search for all of the docket numbers where there is a charge status code is "PW". When it finds "PW", I want to see all of the charges for that docket number, not just the "PW".
Example:
Docket 12345678
Charge A Status CC
Charge B Status PW
Charge C Status SS
I need the report to show Charge A and Charge C, not just Charge B.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
