Month Names

[Al]

Hi, hope someone can help

I need to set up a table with 12 records - one for each month name.

When I display the data I need to sort it so that the current month is at
the top with the following 11 fields going back in Chronological order - eg
currently it would be:

March
February
January
etc

On 1st April I want it to show:
April
March
February
etc etc

Is this possible please and if so, how can it be done. Can add another
field to table if necessary

Thanks

Alex

 

[Cheryl Fischer]

Yes, add a MonthNumber field to your table and insert the month number
appropriate to the MonthName. In a query, you can sort by the MonthNumber
in descending order.

 

[Gerald Stanley]

The following solution reuires a column monthId on the
table where monthNo = 1 for January , 2 for February etc

SELECT {yourMonthName}
FROM {yourTableName}
ORDER BY
IIf(Month(Now())>=[monthId],[monthId],[monthId]-12) DESC;

Hope This Helps
Gerald Stanley MCSD

 

[Al]

Thanks Both - that's sorted

 

[Cheryl Fischer]

You're welcome.