Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 33
Default Problem with Excel getting correct # of records back from Access

I have a qry in MSAccess that brings me 1316 rows, but when I go to excel and
run the qry it only gives me 692 rows. It look like it isn't making it to the
2nd statement or the "Or" statement in the query. Looking at the data in
Excel. I can't remember how to get this to pass all the records over to Excel.

Here's my "Having" part in the Qry:

HAVING ((([Tracking].[Type of Case])="Expedited" Or ([Tracking].[Type of
Case])="Fast Track" Or ([Tracking].[Type of Case])="Standard Pre-Service")
AND (([Tracking].[Appeal or Grievance])="Appeal") AND
(([Tracking].DateRecvd)#1/1/2009#) AND (([Tracking].DateClosedEH) Is Not
Null))

OR ((([Tracking].[Type of Case])<"Part D Standard" And ([Tracking].[Type of
Case])<"Part D Expedited") AND (([Tracking].[Appellant Type]) Like "Member"
& "*") AND (([Tracking].[Appeal or Grievance])="Appeal") AND
(([Tracking].DateRecvd)#1/1/2009#) AND (([Tracking].DateClosedEH) Is Not
Null));

JoeM

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Excel getting correct # of records back from Access JoeM[_3_] Excel Discussion (Misc queries) 0 March 31st 10 10:35 PM
data not importing from access into Excel in the correct order bonsaimarles Excel Discussion (Misc queries) 3 December 31st 08 11:23 PM
Macro Question - Excel to Access and back again Mike The Newb Excel Discussion (Misc queries) 1 October 19th 06 02:35 PM
Linking Access Records to Excel MayraEllen Excel Worksheet Functions 0 August 21st 06 07:37 PM
Import records from Access to Excel Mark Excel Discussion (Misc queries) 1 December 20th 05 01:43 PM


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

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

About Us

"It's about Microsoft Excel"