Dsum error in query

[Mubashir]

I have made a query in access 2013. It works fine but sometimes it causes appcrash. When I open the database first time and open that query it causes an appcrash but if I open the database and open that same query in design mode and just save it once(without any changes) then it works fine until I close it an re-open it. There is DSUM function which causes this problem. If I remove that dsum then it works fine everytime. Please tell me a solution

[andy49]

Can we see the sql code for the query please?

[Mubashir]

SELECT DISTINCT tblrecord.item_ID, tblrecord.Item_Type, DSum("[Quantity]","tblrecord","[Item_ID] =" & [Item_ID]) AS Consumed
FROM tblrecord;

[andy49]

Seems ok. Do you have some data you could zip and put on here?

It might help us to see a replicate of the error


Sent from my iPhone using Tapatalk