How do I set up my report in date order?

[Guest]

Having trouble... want to set up my report so the data will print in
month/year order. For example, 11/04 before 12/04, 12/04 before 1/05, etc..
or November 04 before December 04 etc... Right now, it's reading characters
in order - not sure how to fix that. Thanks.

 

[Rick B]

in your sort put sort something like...

= Format([SomeDateField],"mmdd")

I'm not positive you actually have a date field here though. If you do, it
should be sorting by the year, then the month, then the day. If you are
using a text field and calling it a date, then you have a different
situation, but it seems that it would always sort correctly if that was the
case.

Rick B

 

[Guest]

Ok, I was doing it as a text field. I changed it to date and did my format
as mm/yy. However, when I type in yy as 05, it defaults to 04. Any idea why?

in your sort put sort something like...

= Format([SomeDateField],"mmdd")

I'm not positive you actually have a date field here though. If you do, it
should be sorting by the year, then the month, then the day. If you are
using a text field and calling it a date, then you have a different
situation, but it seems that it would always sort correctly if that was the
case.

Rick B

Having trouble... want to set up my report so the data will print in
month/year order. For example, 11/04 before 12/04, 12/04 before 1/05, etc..
or November 04 before December 04 etc... Right now, it's reading characters
in order - not sure how to fix that. Thanks.

 

[Rick B]

when you type in yy? You are talking about sorting data in a report, not
inputting data.

When you input a date, you need to enter the entire date (01/02/04). If you
are only entering 4 numbers, then it is assuming you are entering a month
and day. It then defaults the current year.

A dat field contains a number which represents the actual date. When doing
data entry you will need to actually enter the entire date.

Sorting, reporting, grouping, etc. can then be done by pulling out a portion
of that date.

Rick B

Ok, I was doing it as a text field. I changed it to date and did my format
as mm/yy. However, when I type in yy as 05, it defaults to 04. Any idea why?

in your sort put sort something like...

= Format([SomeDateField],"mmdd")

I'm not positive you actually have a date field here though. If you do, it
should be sorting by the year, then the month, then the day. If you are
using a text field and calling it a date, then you have a different
situation, but it seems that it would always sort correctly if that was the
case.

Rick B

Having trouble... want to set up my report so the data will print in
month/year order. For example, 11/04 before 12/04, 12/04 before 1/05, etc..
or November 04 before December 04 etc... Right now, it's reading characters
in order - not sure how to fix that. Thanks.

 

[Guest]

As you can see I'm new to this - that answers my question, got it now - thank
you!!

when you type in yy? You are talking about sorting data in a report, not
inputting data.

When you input a date, you need to enter the entire date (01/02/04). If you
are only entering 4 numbers, then it is assuming you are entering a month
and day. It then defaults the current year.

A dat field contains a number which represents the actual date. When doing
data entry you will need to actually enter the entire date.

Sorting, reporting, grouping, etc. can then be done by pulling out a portion
of that date.

Rick B

Ok, I was doing it as a text field. I changed it to date and did my format
as mm/yy. However, when I type in yy as 05, it defaults to 04. Any idea why?

in your sort put sort something like...

= Format([SomeDateField],"mmdd")

I'm not positive you actually have a date field here though. If you do, it
should be sorting by the year, then the month, then the day. If you are
using a text field and calling it a date, then you have a different
situation, but it seems that it would always sort correctly if that was the
case.

Rick B





Having trouble... want to set up my report so the data will print in
month/year order. For example, 11/04 before 12/04, 12/04 before 1/05,
etc..
or November 04 before December 04 etc... Right now, it's reading
characters
in order - not sure how to fix that. Thanks.