Module

[Guest]

This is actually a Module question and it's very general..
Could somone just help me understand what this code is doing?


stFrom = "from [bcbsfl\a4r6].QMS_tblQualityData QD LEFT JOIN
[bcbsfl\a4r6].QMS_tblQualityProvider QP on QD.ICNNO=QP.ICNNO "
stWhere = " WHERE receiptdate BETWEEN '" & begindate & "' and '" &
enddate & "' "


Thanks

 

[John Spencer]

It is building two strings to be added together (concatenated) to form a
query string.

By the way, the line with stWhere is probably going to fail if you are using
Access plus Jet (an .mdb file). If you are using an .adp then it would
probably work.