[AccessD] Updatable UNION?

Charlotte Foust cfoust at infostatsystems.com
Fri Nov 19 11:28:26 CST 2004


Are you thinking of the tip on using a UNION to add an "ALL" selection
to a dropdown list?

Charlotte Foust


-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net] 
Sent: Friday, November 19, 2004 8:40 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Updatable UNION?


Yeah, I just have this nagging little "tip" that I can't seem to fully
remember -- and it may not have anything to do with making UNION
updateable, but rather using UNION in some other non-traditional manner.
I hate having everything boxed up. :( 

Susan H. 

IIRC, UNION ALL doesn't make the query updateable, it just returns all
records from the unioned tables, without eliminating duplicate records.


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