Sum values in Query

[Dan2kx]

Hello, i am need to sum some data as so..

StaffID, RequestID, MinutesUsed

StaffID limited by combobox on form,
requestID (contains a duplicate numbers reletive to the point the record is created e.g. 10 records added contain "1" next time the procedure (for that staff) is records will be "2"),
Minutes used is what i want to sum and i want to sum by limiting the sum to the highest RecordID ( it sums all entries when i do it)

eg
StaffID requestID MinutesUsed
1 1 100
1 1 150
1 1 200
1 2 100
1 2 200
1 3 100

Make sense??

i would prefer a dlookup so that i can use the value in VBA or
ideally i want this to be an update query but that removed the sum field.
ive tried dsum and dlast and other function but it doesnt seem to acheive what i want.

thanks and i will probly kick my self cos its so easy

[puppydogbuddy]

Hello, i am need to sum some data as so..

StaffID, RequestID, MinutesUsed

StaffID limited by combobox on form,
requestID (contains a duplicate numbers reletive to the point the record is created e.g. 10 records added contain "1" next time the procedure (for that staff) is records will be "2"),
Minutes used is what i want to sum and i want to sum by limiting the sum to the highest RecordID ( it sums all entries when i do it)

eg
StaffID requestID MinutesUsed
1 1 100
1 1 150
1 1 200
1 2 100
1 2 200
1 3 100

Make sense??

i would prefer a dlookup so that i can use the value in VBA or
ideally i want this to be an update query but that removed the sum field.
ive tried dsum and dlast and other function but it doesnt seem to acheive what i want.

thanks and i will probly kick my self cos its so easy

I am not sure what you want, but try this:

SELECT a.StaffID, a.RequestID, Sum(a.MinutesUsed)
FROM TableX AS a
GROUP BY a.StaffID, a.RequestID
HAVING a.RequestID =
(SELECT max(RequestID)
FROM TableX As b
WHERE b.StaffID = a.StaffID
)