JStrittmatter
Technical User
I have a billing database. I have a consumer table consumer service table and a receivable table.
There is a date field in both consumer service andreceivable tables both dates are formatted 3/15/2004.
What I am trying to do is a query to give me a list of those consumer who do not have service this but that have an outstanding balance over the fiscal year July 1 to June 30.
The tables are all linked by a consumer id
Consumer Table
BSSID
First Name
Last Name
Address
etc...
Consumer Service
BSSID
Date (12/1/2004)
Trips
Fare
Receivable
BSSID
Date (12/15/2004)
Amount
Check Number
If anyone can get me pointed in the right direction I would really appreciate it.
There is a date field in both consumer service andreceivable tables both dates are formatted 3/15/2004.
What I am trying to do is a query to give me a list of those consumer who do not have service this but that have an outstanding balance over the fiscal year July 1 to June 30.
The tables are all linked by a consumer id
Consumer Table
BSSID
First Name
Last Name
Address
etc...
Consumer Service
BSSID
Date (12/1/2004)
Trips
Fare
Receivable
BSSID
Date (12/15/2004)
Amount
Check Number
If anyone can get me pointed in the right direction I would really appreciate it.