I have a table in Access with information (see attached). I'm trying to figure out if there is a way to get the sum of a column (field) where a certain criteria in two other fields is met. For example, I'd like to get year to date (YTD) totals for a given account. So, I'd need the total sales for a given account (criteria #1) for all months between Jan. and the current records Month. Does anyone know if there is a way to do this in Access?