Module

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top