Lasidu Chamikara
New member
- Local time
- Today, 14:12
- Joined
- Apr 9, 2020
- Messages
- 6
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 the total journey cost infront of each "CardID" into a new field called "Debits". There I used DSum function as mentioned below, but it returns #Error.
Debits: DSum("Cost","ChargeQuery","CardID=" & [CardID])
There is a CardID field in both queries.
Please help me to fix this error.. This is urgent.
Thanks!
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 the total journey cost infront of each "CardID" into a new field called "Debits". There I used DSum function as mentioned below, but it returns #Error.
Debits: DSum("Cost","ChargeQuery","CardID=" & [CardID])
There is a CardID field in both queries.
Please help me to fix this error.. This is urgent.
Thanks!