Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
data not importing from access into Excel in the correct order bonsaimarles Excel Discussion (Misc queries) 3 December 31st 08 11:23 PM
Import Access records into Excel dksaluki Excel Discussion (Misc queries) 1 December 20th 07 07:08 AM
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 05:49 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"