MS Access

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Wish to use a query to create a table from other table
fields, however, wish to create new fields that will be
populated at a later date using update query. Is this
possible?
So far found I have to create new field as say
Test:[test1] which then prompts for input, populates the
field, however, the field type is binary, it's so even if
I format the field in the query as fixed or general. Field
size default becomes 500.
Any ideas?
 
Can you create the table the way you want it and then use an Append query to
populate it, instead of a Make Table query?
 
Wish to use a query to create a table from other table
fields, however, wish to create new fields that will be
populated at a later date using update query. Is this
possible?
So far found I have to create new field as say
Test:[test1] which then prompts for input, populates the
field, however, the field type is binary, it's so even if
I format the field in the query as fixed or general. Field
size default becomes 500.
Any ideas?
Click to expand...

You can include a calculated field:

TextForLater: ""

This will be recognized as a Text value since it's a string, but will
actually load a NULL since it's zero length. It will be defined with
length 255, but since Access doesn't store trailing blanks, it won't
actually take up any space.

Note that MakeTable queries are (in my experience) *very rarely*
really necessary. Since you can base a Form, a Report, an export, or
even another query on a Select Query, it would be well to carefully
consider whether you really want to store this data redundantly in a
new table!
 
Back
Top