Make Table Query

T

Ted

I have a make-table query that is based on a linked table.
When the process completes all of my fields are text. How
can I control this? I need to define one field as a date
and 2 others as numbers.

After the table is built, I can go in and change the
properties on the fields in question, but I'm trying to
run this through a macro so that I don't have to manually
touch the table every time it get re-built.
 
I

Immanuel Sibero

Hi

Instead of running a make table query, how about creating the desired table
first and running an append query against that table?
If you need to blank out the table before running the append query, run a
delete query first. This way the table structure will always be the way you
need it (no need to change from text fields to date, numbers etc.)


HTH,
Immanuel Sibero
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Macro for Table of Contents 2
Combo or list box 0

Top