Sort by Date with Text as datatype 1

[TTF]

I've built Access Report that shows Date by SuperLastName.
How can I force Dates to be sorted Asc if datatype is text?

Thanks

 

[TheAceMan1]

How are ya tektipsFanny . . . . .

[blue]I've built Access Report that [purple]shows Date by SuperLastName.[/purple][/blue]

Not quite sure [purple]what you mean by this[/purple] . . . . be a little more specific . . .

See Ya! . . . . . .

 

[TTF]

I meant that it data does not sort by Date primarely but by Lastname, Unit and Date
I wasn't sure if it is important. Thanks

 

[TheAceMan1]

OK tektipsFanny . . . . .

Easiest would be to [blue]base the report on a query, adding the following CustomField[/blue] ([blue]You![/blue] substitute proper names in [/b][/purple]purple[/b][/purple]):

[blue]QDate:DateValue([purple][b]YourDateFieldName[/b][/purple])[/blue]

[blue]Then you can easily do your sorting in the query . . .[/blue]

See Ya! . . . . . .

 

[TTF]

THANKS, exactly what I needed!