Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Carrying out calculations on segments of data from within a workbo | Excel Worksheet Functions | |||
File Paths and Carrying Data into Future Budget Periods | Setting up and Configuration of Excel | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Carrying data over in worksheets | Excel Worksheet Functions | |||
Carrying Detail Data to Subtotal Row | Excel Worksheet Functions |