Access Sorting in Access 2000

Joined
Mar 23, 2009
Messages
1
Reaction score
0
I have an application written in Access 2000 (by me) that no longer recognizes the prefix sorting instructions in a report. For example, in a design view, under sorting, i can no longer use the prefix characters parameter. When i do i get the following message:
Function is not available in expressions in query expressions 'Left(Lname, 2)'

This used to work, but this is the first time using Vista. Has something been discontinued?

Thanks
 

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

Top