J
JoeM
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
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