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

G

Guest

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

Multiple group levels and aggregate function for text field 2
file download question in C# and asp.net 2
data was messed up after importing from Excel to Access 2000 datab 3
Possible revamp of tables - ideas? 3
Date Question, not sure which forum 2
Hardware still missing drivers support... 13
The Search Key was not found in any record... 0
another veiled PS4 announcement: IBM-Sony-Toshiba Broaden and Extend Successful Semiconductor Techno 0

Top