Continuous Form - OrderBy

[Guest]

Hi Guys,

Is it possible to type two field names in OrderBy property?

e.g

OrderBy: [Date];[Time]

This works find, but when i exit the DB and start the application again it
seems to delete the field names.

Any thoughts?

Greg.

 

[Guest]

PROBLEM SOLVED - I needed the table name in there too.

 

[fredg]

PROBLEM SOLVED - I needed the table name in there too.

Hi Guys,

Is it possible to type two field names in OrderBy property?

e.g

OrderBy: [Date];[Time]

This works find, but when i exit the DB and start the application again it
seems to delete the field names.

Any thoughts?

Greg.

Glad you solve your problem, but you're not quite out of the woods
yet.

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'