When exporting data using the TransferText utility, I get
errors whenever I give the output file an extension other
than .txt, .csv, or one of the other standard text file
extensions.

How can one combine the existing tables automatically into
a single table as opposed to hard-wiring the table names
into a "UNION" SQL Query.

Using Access 2K2; experience level: beginner
============================================
I get a "Type Mis-Match" error when I press any of the option group buttons.
(I am virtually copying the Customer Phone List form and macro from the

I am trying to get the city, state, and zip using the Dlookup function
while using one unbound text box.  I know how to work it with on
field, but I need all three fields in the expression.
the formula I use for the one field is: