Best way to check date.

[Playerpawn]

EDIT:

Can the following part of my select statement be improved:

SUM(IIf(Month(sub.date_entered) = Month(now()) & Year(sub.date_entered) = Year(now()), sub.qty, 0)) as current_month,


SUM(IIf(Month(sub.date_entered) = Month(DateAdd("m",-1,date())) & Year(sub.date_entered) = Year(DateAdd("m",-1,date())), sub.qty, 0)) as prior_1

... followed by lines summing sub.qty going back month by month into seperate columns.

2nd question: How in Access can I dynamically alias the columns (as they will need to adjust depending on current month).

Seems to not work. Always evaluates as 0. I assume I can't use & for two conditions. I'll Google that one.

[June7]

Cannot dynamically alias column names.

Ampersand is concatenation operator, AND is logical operator, along with OR.