Search results

Thanks for reminding, I just crossed checked again, could figure out one field of CardID was not set as number. Now it works... Thanks again!!!

Yes CardID is a number feild SELECT CardInfo.CardID, PassengerInfo.PassengerName, CardInfo.OpeningCardBalance, DSum("TopUpAmount","TopUpInfo","CardID=" & [CardID]) AS TopUpSum, [OpeningCardBalance]+[TopUpSum] AS Credits, DSum("Cost","ChargeQuery","CardID=" & [CardID]) AS Debits FROM...

Hi there, In my database, there's a query named "ChargeQuery" which i use to find the relevant journey charge "Cost" when i enter the journey starting and ending location. There i used DLookUp function to find the value of "Cost". In a separate query named "TransactionQuery", I want to sum up...

Thank you very much for replying. I'm not very much good on Access, just a beginner. Here what I actually want to happen; there is an "Add Record" button in my form and when the user clicks it, I want to add the record as well as display a message box consisting what he has entered. Can you...

Hii, in my database, after entering required data in designed fields in a form, I want to display a message box as well as add those records to the relevant table at the same time. How can I perform this using a single button not with two separate buttons?

I just joined the community. I'm a beginner to MS Access World:)