DocBlack4444
New member
- Local time
- Today, 11:30
- Joined
- Oct 16, 2019
- Messages
- 12
Hello,
Need some advice. I have a VERY simple database set up to help a friend of mine to keep track of very simple plumbing business. he has been using for a while, but asked if i could figure out how to subtotal what customers still owe him so he does not have to do the math.
I made three tables, one for accounts, one for Payments and the other for purchases. one main form that has both payments and purchases embedded as tables as well as lists the account information.
I tried to figure out how to subtotal the payments table on the main form but all i get is ?name, i know that means that it doesn't know what part i am talking about, but i know that the embedded table is Child58.....so i am simply confused. any help would be greatly appreciated.
Need some advice. I have a VERY simple database set up to help a friend of mine to keep track of very simple plumbing business. he has been using for a while, but asked if i could figure out how to subtotal what customers still owe him so he does not have to do the math.
I made three tables, one for accounts, one for Payments and the other for purchases. one main form that has both payments and purchases embedded as tables as well as lists the account information.
I tried to figure out how to subtotal the payments table on the main form but all i get is ?name, i know that means that it doesn't know what part i am talking about, but i know that the embedded table is Child58.....so i am simply confused. any help would be greatly appreciated.