"Group By" problem
We have a query that has been working quite happily for over ayear, but has
suddenly decided to play up, giving a "No current record" message box. The
query is a Group By type, with just one of the items (hours) being "Sum". If
we remove the Group By, the query works fine.
We suspect a data problem, but cannot pinpoint it. Null is permitted in the
hours field, and has been there in the data in the past. Any clues, please?
JMCS
|