Date format

Hi There,

I have formatted the date as follows:

Month: Format([directors Meeting day],"mmmm" & "- " & "YY")

This gives me 08/31/2004 as August-04 but the problem is, how do i make the thing work in ascending order.

For example:

August -04
December -04
January-05
June-04

I want them to be in the ascending order as

June-04
August -04
December -04
January-05

Your advise/input is highly appreciated.

Rishy

Rishy,

In your query make a new column Year([directors Meeting day]) This will give you the year...Sort ascending in this column.

Then make another column Month([directors Meeting day]) This will give you the month as a number. Then sort ascending in this column.

Both columns can be hidden, but make sure you sort by year first then by the month.

lwells

Thanks Iwells. Your suggestion was very helpful.

Well, but got stuck on next step.

I have the following condition.

Columns in a query are
Actionofficers Actiondirectors
1. Approved Approved
2. Declined Accepted report
3. Approved Blank-Null
4. Approved Declined.
5. Approved Tabled

I made another column with the following condition.

Actionoverall: IIf([actiondirectors] Is Null,[action],[actiondirectors]).This helped me in filling up the blank spaces in action by directors with action of officers and i would give the criteria <>declined and <> tabled. This works fine.

I WANT a condition apart from the above one, which says, if action officers=declined and if action directors = accepted report then take action officers(declined).

Any help in appreciated.

Rishy

Rishy

Is this the same type of question in your other post? Otherwise you have two conditions that will either provide either a TRUE or FALSE statement.

IIf([actionofficers]="declined" And [actiondirectors]="accepted report", TRUE part, FALSE part)

lwells