Now for my next question...

  • Thread starter Thread starter Lurch
  • Start date Start date
L

Lurch

Again, I have a query which will be attached to a form. (Maybe I should be
in the queries forum-Sorry if I should)

This query has a table which has the twelve months. How can I get it to add
only the months up to the current month? If it is March add Jan, Feb and
March. If it is April, well you get the idea.

I'd like to keep it in the query if I could. As I may have many forms that
may rely on it.
 
Dear Lurch:

Your table of 12 month names needs to also have a column like MonthNo
which contains integers 1 to 12, putting them in order.

Then, you can say:

WHERE MonthNo <= MONTH(Date())

so you get January, February, and March.

Make sense?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top