SUM Function - Using Properly?

[Stang70Fastback]

Simple question guys. If I have a Query, and I want to list the sum of one of the columns of that query in another text box on a form, is this the correct way of doing it?

=Sum([Drivers Other Shifts].[Duration])

In this case, "Drivers Other Shifts" is the name of the Query, and "Duration" is the column header. When I try this I get #ERROR, so I have no idea if it's just that something else is wrong, or that my expression is the wrong way to go about it... Any thoughts?

 

[Alansidman]

Look at using the DSum function. But it might work better if you use the table name where the data is versus the query. I haven't tried using a DSum on a Query, but maybe?

http://www.techonthenet.com/access/functions/domain/dsum.php

 

[Stang70Fastback]

I... love... you!