Lots of swearing ..
OK I have a report and I intend to email out - (I can handle this )
I want to export Statementrptemail as pdf - (not an issue)
however when I run this I get all of the statemetns instead of one AccountNo
so
Brown Eggs - 1 report
Sugar Daddy 1 report
currently i am getting 2 reports but with both of the above - ..i know its to do with " or @ but its thrown me .
DoCmd.OpenReport "Statementrptemail", acViewPreview, , "AccountNo = " & rsEmail.Fields(0) & " '"
OK I have a report and I intend to email out - (I can handle this )
I want to export Statementrptemail as pdf - (not an issue)
however when I run this I get all of the statemetns instead of one AccountNo
so
Brown Eggs - 1 report
Sugar Daddy 1 report
currently i am getting 2 reports but with both of the above - ..i know its to do with " or @ but its thrown me .
DoCmd.OpenReport "Statementrptemail", acViewPreview, , "AccountNo = " & rsEmail.Fields(0) & " '"