Converting memo to text using query (to form a new table)

[KK]

Hi,

Just a quick & urgent question - I'm trying to create a table from a
query to change a field spec in the original table (from 'memo' to
'field').

I cannot change this spec in the design view due to memory restrictions
-

This is whatb I've tried in the query (design view, Field):
OFC: Left([Orig Fin Class],4)
OFC is the new field I want to create with a text spec, Orig Fin Class
is the field with the 'memo' spec in the original table. 4 is just an
arbit number

If anyone could help me here, I'd be very thankful!

KK

 

[Guest]

hi,

First make sure your database is not over 1.90GB.

I tried this, and it works just fine. Create a new query, with a new
column, taking the Left 4 or whatever number.

If there is still a problem, make a query in which you take the Memo field,
the Left N of the memo field, and the primary key for each record. This will
give you the new Text column.

Then performa an update query which updates the original table with the Text
field values from the above query, for each primary key.

Hope this helps,
geebee

 

[Jeff Boyce]

If I needed to get the leftmost "4" characters of a field, I'd use
NewField: Left([ThatField],4)
as a new field in a query.

What happens when you do this?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

By the way, the query would have to have the table containing that field as
a source.

Regards

Jeff Boyce
Microsoft Office/Access MVP