S
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.
"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.