CODEWITHSUNDEEP
ms-access
PHerzog
PHerzog

Reputation: 11

Calculated Field Data Type in Microsoft Access

On the datasheet view, I need to combine the values from fields that have more than 255 characters into a single field(column). The calculated field truncates the result!

Is there a way to create a Calculated Field with a Long Text data type? If not, what are the best alternatives to get the same result?

Upvotes: 0

Views: 513

Answers (1)

PHerzog
PHerzog

Reputation: 11

Thanks all!

Here was the query I used:

SELECT 
    [HISTORY A-J].CONTACTID, 
    [HISTORY A-J].[ClientView Note] 
FROM 
    [HISTORY A-J] 
WHERE 
    (False)

UNION ALL

SELECT 
    [HISTORY A-J].CONTACTID, 
    [HISTORY A-J].[Created On] & " " & [HISTORY A-J].X_TypeName & " " & [HISTORY A-J].Regarding & " " & [HISTORY A-J].Details & " " & [HISTORY A-J].Attachment_Display & " " & [HISTORY A-J].Attachment_Path & " " & [HISTORY A-J].Attachment_FileName AS Result 
FROM 
    [HISTORY A-J];

Upvotes: 1

Related Questions