A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Group By" problem



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ambiguous outer joins Renwick New Users 1 February 22nd, 2005 03:08 PM
O.E. Address Book Groups Joy Outlook Express 12 February 2nd, 2005 05:13 AM
Mail Merge Problem MT DOJ Help Desk General Discussion 9 July 20th, 2004 04:55 AM
Help Needed for Groups Please Paul Black General Discussion 15 June 21st, 2004 02:54 AM
Product ID For Online Support General Discussions 12 June 7th, 2004 07:34 PM


All times are GMT +1. The time now is 03:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.