[AccessD] Access 2000 - Union query

Charlotte Foust cfoust at infostatsystems.com
Mon Feb 3 10:31:01 CST 2003


I've never found any documentation on it.  I discovered it myself by
accident.  The tricky part is that if you open the query in design view,
it may change the syntax and break.

Charlotte Foust

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Sunday, February 02, 2003 2:55 AM
To: Stuart McLachlan
Subject: Re: [AccessD] Access 2000 - Union query


Hi Stuart

> That's neat. Is that "[.]." syntax documented anywhere?

I don't know.
Charlotte expressed some experience with it - and recommended to be
cautious which could indicate that this is a special syntax accepted by
some engines only. I have only used it with the Jet engine which seems
to accept it, though it is not documented.

/gustav

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list