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 Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

data not carrying over from access to excel



 
 
Thread Tools Display Modes
  #1  
Old March 25th, 2010, 09:03 PM posted to microsoft.public.excel.worksheet.functions
JoeM
external usenet poster
 
Posts: 41
Default data not carrying over from access to excel

When I am running a query in MSAccess 2007 I get 1315 records, when I run the
query via Excel 2007 connecting to the DB it stops at 691 records. I'm a
little rusty, this is my only query where in the criteria I have an "or". I
was thinking if this had anything to do with a second pass or am I just not
calling it correctly:

SELECT [dbo_Appeal].[Record Number],
[dbo_Appeal].[Type of Case],
[dbo_Appeal].[Appellant Type],
[dbo_Appeal].[Appeal or Grievance],
[dbo_Appeal].DateRecvd,
[dbo_Appeal].DateClosedEH,
[dbo_Appeal].GrievanceReasonID,
[dbo_Appeal].[Case Owner],
[dbo_Appeal].DenialReasonID,
[dbo_Appeal].Region,
[DateClosedEH]-[DateRecvd] AS TAT
FROM [dbo_Appeal]
GROUP BY [dbo_Appeal].[Record Number],
[dbo_Appeal].[Type of Case],
[dbo_Appeal].[Appellant Type],
[dbo_Appeal].[Appeal or Grievance],
[dbo_Appeal].DateRecvd,
[dbo_Appeal].DateClosedEH,
[dbo_Appeal].GrievanceReasonID,
[dbo_Appeal].[Case Owner],
[dbo_Appeal].DenialReasonID,
[dbo_Appeal].Region
HAVING ((([dbo_Appeal].[Type of Case])="Expedited"
Or ([dbo_Appeal].[Type of Case])="Fast Track"
Or ([dbo_Appeal].[Type of Case])="Standard Pre-Service")
AND (([dbo_Appeal].[Appeal or Grievance])="Appeal")
AND (([dbo_Appeal].DateRecvd)#1/1/2009#)
AND (([dbo_Appeal].DateClosedEH) Is Not Null))
OR ((([dbo_Appeal].[Type of Case])"Part D Standard"
And ([dbo_Appeal].[Type of Case])"Part D Expedited")
AND (([dbo_Appeal].[Appellant Type]) Like "Member" & "*")
AND (([dbo_Appeal].[Appeal or Grievance])="Appeal")
AND (([dbo_Appeal].DateRecvd)#1/1/2009#) AND (([dbo_Appeal].DateClosedEH)
Is Not Null));

Joe
 




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


All times are GMT +1. The time now is 08:25 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.