My report puts feb 2006 before January 2006, and December 05

B

bvolkertcc

I have a report with almost 900 records. As you click from report 1, 2, 3,
etc..all the dates are in chron order. Yet, February 2006 shows before
December 05 and January 06. I import the data from an Excel spreadsheet.
Both Excel and Access field are in date format. Any suggestions? Also, I
have deleted some records so although it is almost 900 the record number goes
up to 1200.
 
D

Duane Hookom

You might want to tell us the expressions/fields you used in the report's
sorting and grouping levels....

If you view your "date" column in datasheet, does it align left or right?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 dimensional date sort 2
TEXT DATE Format Conversion 1
Report with disappearing subreports - null values 3
Multiple group levels and aggregate function for text field 2
report "this expression is typed Incorrectly...", query works 1
go to cell with date equaling TODAY() 1
Carrying a Date throughout the application 1
match data by day 1

Top