soirt

[Chey]

I have this in the grouping and sorting
=Month([theMonth])
My months though are january 05 all the way to December 06
How can I get it to sort with the year also?

Thanks

 

[Rick B]

= Year([YourDateField]) (in the first line)
= Month([YourDateField]) (in the second line)

 

[Chey]

now it only gives me one month
=Year([theMonth])
Yes
No
Each Value
1
Whole Group
=Month([theMonth])
Yes
No
Each Value
1
Whole Group

When put the year first it only gives me 1 month and year
when i put the month first it gives me what I had before.

Thanks
Chey

= Year([YourDateField]) (in the first line)
= Month([YourDateField]) (in the second line)


--
Rick B

I have this in the grouping and sorting
=Month([theMonth])
My months though are january 05 all the way to December 06
How can I get it to sort with the year also?

Thanks

 

[Rick B]

What type of field is stored in the "theMonth"?


--
Rick B

now it only gives me one month
=Year([theMonth])
Yes
No
Each Value
1
Whole Group
=Month([theMonth])
Yes
No
Each Value
1
Whole Group

When put the year first it only gives me 1 month and year
when i put the month first it gives me what I had before.

Thanks
Chey

= Year([YourDateField]) (in the first line)
= Month([YourDateField]) (in the second line)


--
Rick B

I have this in the grouping and sorting
=Month([theMonth])
My months though are january 05 all the way to December 06
How can I get it to sort with the year also?

Thanks

 

[Chey]

It is a text field
The months and year are listed
Jan 05
Feb 05
March 05
all the way to Jan 06

I want it to sort in order.
Thanks

What type of field is stored in the "theMonth"?


--
Rick B

now it only gives me one month
=Year([theMonth])
Yes
No
Each Value
1
Whole Group
=Month([theMonth])
Yes
No
Each Value
1
Whole Group

When put the year first it only gives me 1 month and year
when i put the month first it gives me what I had before.

Thanks
Chey

= Year([YourDateField]) (in the first line)
= Month([YourDateField]) (in the second line)


--
Rick B



I have this in the grouping and sorting
=Month([theMonth])
My months though are january 05 all the way to December 06
How can I get it to sort with the year also?

Thanks