I have a database and I want to create a query (using SQL) that just gives me the Sum of 1 field for the records in question. For Instance, I want my query to sum the total of [Amount] for all records that [DateYr1] = 2008 and [DateYr2] = 2010 and [Amount] > 0.
Is that possible? I'm not having any luck.
Is that possible? I'm not having any luck.
