soirt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
= Year([YourDateField]) (in the first line)
= Month([YourDateField]) (in the second line)
 
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

Rick B said:
= Year([YourDateField]) (in the first line)
= Month([YourDateField]) (in the second line)


--
Rick B



Chey said:
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
Click to expand...
Click to expand...
 
What type of field is stored in the "theMonth"?


--
Rick B



Chey said:
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

Rick B said:
= Year([YourDateField]) (in the first line)
= Month([YourDateField]) (in the second line)


--
Rick B



Chey said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Rick B said:
What type of field is stored in the "theMonth"?


--
Rick B



Chey said:
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

Rick B said:
= 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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top