Query Sort Order

[Fozi]

Attached is a query which for the life of me I cannot get to order as it should.

It is linked to a master table containing staff timesheet entries by week. I want the query to display in the correct sort order (by StaffName, by Date) showing a running total of overtime accrued by each person.

All help greatly appreciated.

Thanks
Fozi

 

[Brianwarnock]

The Sort order is correct for name and weekcommencing, I don't see how it can also include the flexivalue.
I would use a report to produce your running sum requirement.

Brian

 

[Fozi]

Sorry Brian

Didn't explain that too well. The sort order is fine but the values reporting for NextValue are not accurate when compared to the entries within the table. NextValue shoudl show the previous FlexiValue for that member of staff.

Fozi

 

[Rabbie]

Your issue seems completely different now than in your first post. This link may help you find out how to get a value from a previous record

 

[Brianwarnock]

I am not sure that he can do it using a subquery , but maybe if he can use the weekcommencing as his link to the previuos record, maybe, but it takes a minute to do it in a report from start of design to finish.

Brian