The Rev
Registered User.
- Local time
- Today, 00:27
- Joined
- Jan 15, 2003
- Messages
- 118
Good morning. I have a table that lists 30 bills that are paid monthly, and separate checkbox fields for husband and wife. As a bill gets paid, I check the box for who paid. I need a query that will produce a list of how many bills the husband paid, how many the wife paid, and how many are outstanding, like this:
Bill Payor | Total
Husband | 4
Wife | 6
Remaining | 20
I know I can just use total fields and get it across one record, but I need it specifically in that format.
I have been knocking my head into a wall for a few days on this...
Bill Payor | Total
Husband | 4
Wife | 6
Remaining | 20
I know I can just use total fields and get it across one record, but I need it specifically in that format.
I have been knocking my head into a wall for a few days on this...