|
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
| 
