Query syntax differences Access 97 vs 2000

[3G]

Is there a good guide on query syntax differences between MS Access 97 and 2000? I've created a query that works fine on 2000 and gets errors in 97.

Thanks

 

[Magnetar]

Afternoon 3G

One publication you might like to look at is:
'Running Microsoft Access 2000' by John Viescas, (ISBN 1572319348).
For example, page 49 of chapter 3 gives a short list of Key Query Features in Access 2000.
Also in chapter 8:Adding Power with Select Queries for example, features new to Access 2000 are highlighted, (eg the Round function).

Best wishes

Magnetar s-)

 

[3G]

Thanks. I'm having a time of it creating a query that includes info from three tables, with one of them needing the transaction date just prior to the "ending date" entered by the user. I've got one working (in Access 2000 anyway), but it's a nasty mess and there must be an easier way!