Continuous Form - Order By Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I have a Continuos Form called frmNotes with the following fields.

ID: (autotnumber)
Ref: (number)
Date: (short date)
Time: (short time)
Note: (memo)

In properties of frmNotes i have Order By: Date

Unfortunately the results don't appear in order of date.

Any thoughts?

Greg.
 
DISREGARD GUYS - PROBLEM SOLVED.
Click to expand...

For today, OK. But what about next week or next year?

Date and Time are reserved Access/VBA/Jet words and should not be used
as field names.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
 
Back
Top