View Single Post
  #1  
Old October 5th, 2005, 03:20 PM
JMCS
external usenet poster
 
Posts: n/a
Default "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