Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Excel getting correct # of records back from Access | Excel Discussion (Misc queries) | |||
data not importing from access into Excel in the correct order | Excel Discussion (Misc queries) | |||
Macro Question - Excel to Access and back again | Excel Discussion (Misc queries) | |||
Linking Access Records to Excel | Excel Worksheet Functions | |||
Import records from Access to Excel | Excel Discussion (Misc queries) |