view recordset

[seeker]

I have this query:

"select * from los_service where (los_service_date = #" & rpt_date & "# and
service like '*CPST'" & _
") or (los_service_date = #" & rpt_date
& "# and service = 'AAC-CM') order by member_number and los_beg_time"

in vba and it pulls 68 records. When I write a similar query in query
design it sorts by member number with first record as member_number = 94.
The vba first record is member_number = 2217. The rest of the vba compares
one record to another to see if there is an overlap of times. I have a
member 207 which has an overlap but the query in vba appears to not have that
in its record set. Is there a way to view a recordset in vba so that I can
see if that recordset is the same as the one with same code in query design?
Thanks.

 

[seeker]

never mind. the order by should be order by member_number, los_beg_time NOT
order by member_number and los_beg_time