I would like to use a dsum that I use on my form but in my form I reference the Current record ID. Can you do something like this in the query. In the query there is not active id showing, so I am not sure how to do this.
basically I want to query a list of cars and for each car show a total for the repairs done. I do this in the form by referencing the car id, but I can't do that in the query
I am not looking to get a running total, just the total repairs for each car.
Thanks for any help.