Truncation of Memo fields

[purceld2]

I have read an article by Allen Browne where it describes a workaround for a truncation issue of the Memo field where the DISTINT key word

Workaround

Open the query's Properties Sheet and set Unique Values to No. (Alternatively, remove the DISTINCT key word in SQL View.)
You may need to create another query that selects the distinct values without the memo, and then use it as the source for another query that retrieves the memo without de-duplicating.

Can someone explain to me how you go about making a query a source to another query

Thank you in advanced

 

[Rabbie]

JUst use the existing query in the same way you would use a table

 

[boblarson]

To add to Rabbie's brief explanation>

1. Select NEW query and then in the tables selection form you can

2. Select the tab that has QUERIES listed or ALL.

3. Double-click on your query to add it to the current new query

4. Close the selection dialog

5. Continue as if you had a table in the query instead of a query.

 

[John Big Booty]

If I've understood correctly, what you need to do is to create a query that picks up all the distinct values. You then create a query that will pick up the Memo field. Now when you are creating that query you will notice that as well as a tab for Tables there is a tab for Queries, and another one for Both. If you click on the Query tab you will see the query you have already create, add that to the top pane of the query builder and select all it's fields.

 

[John Big Booty]

Beaten to the punch twice Ouch.

 

[purceld2]

Thanks Guys

But I still have the same problem The original query now has 69 lines with the Distinch key word which is correct but you link it with the table which has the memo files it results with the same amount as without the DISTINCT key word code attached what am I doing wrong.

SELECT [CPAB Workstack Ver 1].[Clarity Ref], [CPAB Workstack Ver 1].[CPMG Ref], [CPAB Workstack Ver 1].Priority, [CPAB Workstack Ver 1].[Project Area], [CPAB Workstack Ver 1].[Project Name], [CPAB Workstack Ver 1].[Consumer Owner], [CPAB Workstack Ver 1].Sponsor, [CPAB Workstack Ver 1].[Project Manager], [CPAB Workstack Ver 1].[Start Date], [CPAB Workstack Ver 1].[End Date], [CPAB Workstack Ver 1].[Customer Required Date], [CPAB Workstack Ver 1].OCCD, [CPAB Workstack Ver 1].CCCD, [CPAB Workstack Ver 1].[Amount Signed Off], [CPAB Workstack Ver 1].[OLBC Ref], [CPAB Workstack Ver 1].RAG, [TEST Table].DESCRIPTION, [TEST Table].[Status comment]
FROM [CPAB Workstack Ver 1] INNER JOIN [TEST Table] ON [CPAB Workstack Ver 1].[Clarity Ref] = [TEST Table].[Project code];