I am working with Infomaker on an existing report. The report pulls data by entering in dates. The data extracted consists of customers and their contracts. The report lists each contract number, but each contract may have serveral of the same invoice numbers depending upon what services where done and their dates. If all services for a particular contract are completed, the code column will contain 'PM'. I want to exclude ALL the invoice data from the report IF the code column is = [PM].
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Query Infomaker 9.0 1
- Thread starter kenadys
- Start date
-
1
- #2
Without table structures we just have to guess bot something like should work.
select * from contracts where date between somedate and someotherdate and
not exists
(select * from invoice where code = 'PM' and
invoice.contractid = contract.id )
select * from contracts where date between somedate and someotherdate and
not exists
(select * from invoice where code = 'PM' and
invoice.contractid = contract.id )
- Status
Similar threads
- Locked
- Question