Hi,
I would like to use the SQL statement below as my query. It work properly in VB's Dataenvironment, but not in DAO (programmatically). Any ideas?
sqlstr = "SELECT SUM(TTotal), SUM(PTotal) FROM " & _
"(SELECT SUM(addlog.tran_bal) AS TTotal, SUM(0) AS PTotal " & _
"From Addlog Union " & _
"SELECT SUM(0) AS Total, SUM(eftlog.tran_bal) AS PTotal " & _
"FROM eftlog)"
Thank you.
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...