setting data types in a mktbl qry

[jordan.macy]

Hi gang - I'm concatenating several fields in a mktbl qry and to
preserve the data integrity, I need to make sure the new field will
have the data type of "memo" (so I don't lose text!)

Is there an easy way to do this?

I've already tried formatting the destination table, but running the
mktbl qry each time creates a brand new table. Interestingly, other
fields have data types already associated with them (date, integer,
text, etc...)

Many thanks for your advice! (insert chocolate chip cookie here)

 

[Jeff Boyce]

Consider taking a slightly different approach.

Instead of recreating the table (make table) each time, is there a chance
you can simply use the query itself as your source? !No new table required!
if this works.

If you MUST have a table (and storing calculated values is not a good idea,
for a number of reasons), instead of recreating a new one every time, you
could build a table once, with the datatypes you need, then simply append
your records to that table. If you need a "clean slate", first run a delete
query to empty that table, then append.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[jordan.macy]

Consider taking a slightly different approach.

Instead of recreating the table (make table) each time, is there a chance
you can simply use the query itself as your source? !No new table required!
if this works.

If you MUST have a table (and storing calculated values is not a good idea,
for a number of reasons), instead of recreating a new one every time, you
could build a table once, with the datatypes you need, then simply append
your records to that table. If you need a "clean slate", first run a delete
query to empty that table, then append.

Regards

Jeff Boyce
Microsoft Office/Access MVP









- Show quoted text -

Thanks - I didn't think of turning it into an append query... I'll
give it a shot and see if it works!

Regards,
Jordan