Defining an MS Access column alias to use in a function

[sheppardpg]

I am creating a Make Table Query "tc_TelecomMakeTable" to make the table tc_TelecomExport. There is a field in the table named "Comments". The "Comments" field in the table needs to have the data type of Memo. The "Comments" field in the query is labeled with an alias "Comments:""" and assigned no value.

If I use a field from an already existing table as a test for the Memo Object it works, but when I change it to the alias I can’t figure out how to grab the AS Comments from the SQL statement. Remember this is Access I'm working in.

Public Function datatype()
MEMO (Comments)
End Function

What I think I need is to do is assign the data type of Memo to the Alias field in the Query.

Sincerely,
Phil S.

 

[sheppardpg]

Got an answer

thanks
Phil S.

 

[lespaul]

would you mind sharing it with the forum so that others can benefit?

Leslie

Have you met Hardy Heron?

 

[sheppardpg]

Well the answer I got was that it was not possible to do it with a function like I'd like.

It was suggested that instead of creating a make table query, I create a table set the data types and then create an append query. However the field appends as text and I still have to manually change it memo.

I'm not sure how I'm going to handle it, but I know theirs got to be a way to set the memo data type on a column alias in the query design grid of Access which is application I'm using.

So I'm still looking for an answer but it should probably be done in a new thread that is more descriptive of the problem I'm trying to solve.

Thanks
Phil S.