C
C
This may be a long way of fixing the problem but - set the
field to Date/Time and have the Users enter in the same
date format ex. 01/01/00 for January 02/01/00 for February
etc...regardless of the year or date. For reports go to
the properties of that date field and change the format
to "mmm" the month will show up as Jan and will sort
correctly other wise the database does not recognize it as
a date and will continue to sort alphabetically. C
Well, when we run reports it sorts it in alphabetical
order. How can I make it sort by month even though there
is no date format available for abbreviated months??
field to Date/Time and have the Users enter in the same
date format ex. 01/01/00 for January 02/01/00 for February
etc...regardless of the year or date. For reports go to
the properties of that date field and change the format
to "mmm" the month will show up as Jan and will sort
correctly other wise the database does not recognize it as
a date and will continue to sort alphabetically. C
etc.) The format for that field in the table is TEXT.
Well, when we run reports it sorts it in alphabetical
order. How can I make it sort by month even though there
is no date format available for abbreviated months??