Sub query problem Access 97

[Mark Reed]

Hi all,
The background is:
I have a database at work which runs on 97.
I have copied this database and bought it home to try new things with it. My
home Access version is 2000. At home, I have included a subquery on one of
the query's which works a treat. I mailed the query to work and added it to
my DB there. When I run it, I get the following error:

Syntax error in FROM clause. (Error 3131)
You entered an SQL statement that has an invalid FROM clause.
Possible causes:

· A reserved word or argument name is misspelled or missing.
· Punctuation is incorrect.
This is exactly the same database and query apart from the subquery I have
just added and the version of access I am running it on. The new query is as
follows:

SELECT testb.dandt, testb.forname, testb.surname, (Select Max([dandt]) from
testa
Where testa.dandt < testb.[dandt]) AS previous
FROM testa AS testb;

Could anyone tell me the cause of this and perhaps a remedy?

The help files are not much help.

Thanks in advance,

Mark