Recent content by Roberto_Giussani

Thank you for your reply. Sorry but I am principiant and don't understand what I have to do. Please con you send me a sample ? THANKS again

one last clarification ... if I put a button in the customer form that executes the query, what should I enter to get the amount of the customer concerned as a result?

osservazione corretta...grazie...creerò un pulsante nella scheda cliente che mi darà il valore aggiornato...grazie mille

ok work correctly but now I want put the "Amount outstanding" in the field of the customer table ... how I can do ? I think that this is my last request

Now work ... but how I can find or copy the "Amount outstanding" in the field of the customer table ?

ok the first query work correctly ... but second one no ... Now join that to the customer table in a second query a and make a calculated column (AmountDue: [SumofLesson_Price] -[SumPayment_Amount]) Sorry but I am principiant ... thank you from Italy

thank you for your reply ... but may be I make a mistake ... Query2 don't work

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...

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...