What is the correct syntax to query a access database that will sum one field and sum the same field if a certain date is is contained in that field
my code is
Dim mannasum As Currency
Dim mannaredeemed As Currency
Dim ddate As Date
ddate = "1/1/2000"
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"\test\Database\Manna Gold.mdb;Persist Security Info=False"
.RecordSource = "select sum([Amount]) as TotalMannaSum from [Manna Gold] & WHERE [exchanged date]>#" & ddate & "# "
This query works but I want to also want to get the sum of all [Amount]. Can this be in the same query or do I need a second query?