Make report sort by IDs and then by Date

[taimysho0]

Hello, i want my report to sort by ID number, then by Date (im using access 2010). My date column values are in C(Date) format. However, when the report sorts it, it treats the values as if it were text so for example instead of listing like this:



1/1/2012
1/2/2012
1/11/2012


it goes:

1/1/2012
1/11/2012
1/2/2012

pleas help, picture atatched of my current setup in the report sort portion. thanks!

[RayMilhon]

Unfortunately there is not enough info here. However from your description and the image showing "with A on top" it looks like that is not a date field but a text field. So either the field within the table is text formatted or you're formatting the date for a specific format and that formatting has the query displaying the field as text not a date, but that's only a guess as I can't see the underlying query or table structure

[taimysho0]

as mentioned above, the data in the particular column was originally in text format. I used a CDate([Column]) function to convert the values into dates. When i sort the column from low to high, it sorts it correctly and treats the values as dates. However, when i put it into the report, it treats it as text even though its from the same column...

[RayMilhon]

Do the sort in the query not the report that should fix it.

[taimysho0]

thanks! fixed it