Thread: Normalization
View Single Post
  #14  
Old March 13th, 2010, 08:21 PM posted to microsoft.public.access.tablesdbdesign
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Normalization

John W. Vinson wrote in
:

A mailmerge can easily be based on a Query. You certainly do not
need to have it all in one table!


Yes, true. But if your query has any user-defined functions or uses
any VBA functions that are not supported by the Jet/ACE expression
service, it won't work. I almost always use a temp table for writing
data that is exported or used for mail merge.

And I'd also recommend Albert Kallal's Word Merge utility, which
I've used quite successfully in one of my apps:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

(search for Super Easy Word Merge in the page)

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/