Hi,
I'm having a fit with the way Access is rewriting my SQL once I have saved a query and then reopen it...
I am quering a subtable a bit like this:
Which works perfectly as I need it to but then when I save, close and reopen, Access has rewritten as:
I.e. it has replaced my curved brackets ( ) with square ones followed by a full stop [ ]. Now the code won't work and I have to change it back!!
Am I doing something wrong? What do I do to turn off automatic query editing in Access?
Thanks very much.
Robin
I'm having a fit with the way Access is rewriting my SQL once I have saved a query and then reopen it...
I am quering a subtable a bit like this:
Code:
Select mytable.name, mytable.cost From ( Select name, cost, date, store From sometable Where cost > 100 ) mytable
Code:
Select mytable.name, mytable.cost From [ Select name, cost, date, store From somestable Where cost > 100 ]. as mytable
Am I doing something wrong? What do I do to turn off automatic query editing in Access?
Thanks very much.
Robin
Comment