Without a vs forum to post in I guess this is the best choice.
aspx web apges created via vs 2003
using the following code
Dim oleAdapt As New OleDbDataAdapter("SELECT " & _
"reporttoname, sum(finalsales) AS YTDSales, " & _
"sum(0) as MTDSales FROM tbl_GMRData WHERE AccLedgerYear=2005 " & _
"UNION SELECT ALL reporttoname, sum(0) AS YTDSales, " & _
"sum(finalsales) as MTDSales FROM tbl_GMRData WHERE AccLedgerMonth=5 GROUP BY reporttoname", objConn5)
the page returns an error but when I use just the single select statement I get a result. So I know that my connections all work but with any type of union select statement the page errors.
The tbl_GMRData is an access table.
Any help would be greatly appreciated.