QUERY or CALCULATE FIELD ? (1 Viewer)

[Roberto_Giussani]

I need to urgently resolve a problem.

I have a database with these 3 tables CUSTOMER - LESSONS RESERVATION BOOKING - PAYMENT.

I need the residual credit to be calculated in the AMOUNT OUTSTANDING field of the CUSTOMER table,

on the basis of the lessons booked or performed and on the basis of the payments made.

THANK YOU !

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[theDBguy]

Hi. Welcome to AWF!

Since you already reposted your question to the appropriate forum, you can feel free to update the above post to introduce yourself.