Query Problem

[Steve]

I have a query that I have created that has fields from a
table, as well as formulas.
In the table, I have a field that is set as a Memo
type, "pbx Comments". In the query, I have to have
grouping turned on because of the formulas and
calculations. When I query the results, the field that
is set as a Memo type (pbx Comments) only pulls part of
the information from the table. Rough guess of about 255
characters rather than the 65,000 or so.
How can I fix this, since it is needed for a report?

 

[Allen Browne]

Open the query in design view.

In the Total row under the Memo field, change Group By to First. Since
Access does not have to group by the memo field, it is now free to return
the whole thing.

If you have already set up your report, you will need to change the
ControlSource to reflect the new name. For example, if the field was called
MyMemo, Access will have aliased it as FirstOfMyMemo.

 

[Guest]

Thank you. I was looking and looking for a solution (as I
knew that there had to be one). Thank you again.

 

[John Spencer (MVP)]

Instead of group by on the memo field, try FIRST. HOWEVER, this will only
return the memo field from one of the set of records created by the group by actions.

If you need a separate record in the group everytime the memo field is
different, then post back. When you do can you also post the SQL statement for
your query.