S
SharonInGeorgia
I want to combine an exisiting query that contains calculations with a new
query that is run monthly. How can I do this programmtically?
Select * from qry04(with calculations) and Select * from (new) qry03 to
create qry04. The monthly report bounds it's fields from qry04. (I could
use some code help as well as some logic...Thank You!)
DoCmd.OpenQuery "qry01", acNormal, acEdit
DoCmd.OpenQuery "qry02", acNormal, acEdit (THIS IS A PIVOT QUERY)
DoCmd.OpenQuery "qry03", acNormal, acEdit
query that is run monthly. How can I do this programmtically?
Select * from qry04(with calculations) and Select * from (new) qry03 to
create qry04. The monthly report bounds it's fields from qry04. (I could
use some code help as well as some logic...Thank You!)
DoCmd.OpenQuery "qry01", acNormal, acEdit
DoCmd.OpenQuery "qry02", acNormal, acEdit (THIS IS A PIVOT QUERY)
DoCmd.OpenQuery "qry03", acNormal, acEdit