Memo field in query is being cut off 1

[Knish89]

I have a pretty basic query that includes a memo field. When I run this query (or print the report based on the query), the memo field is cut off after about 255 characters.

I tried going to the Design View in the report and changing the "Can Grow" property to "yes", but that didn't work as the memo field appears to be cut off in the query.

I also read somewhere that getting rid of "Group By" might work, but I can't seem to make that work either.

Any thoughts?

 

[dhookom]

Next time, post your SQL view. If the query isn't showing more than 255 characters then you probably have phrases like "GROUP BY", "DISTINCT", or "DISTINCTROW".

Duane
MS Access MVP

 

[Knish89]

Thanks for your response...

Here's the SQL view:

SELECT Main.Number, Main.[Date of Call], Main.[Prospect Name], Main.[Address 1], Main.[Address 2], Main.City, Main.State, Main.[Zip Code], Main.Phone, Main.[Contact Name], Main.[1st_Class_Volume], Main.[1C_Frequency], Main.Standard_Volume, Main.Standard_Frequency, Main.Flats_Volume, Main.Flats_Frequency, Main.International_Volume, Main.International_Frequency, Main.Currently_Presorting, Main.Presort_Vendor_Name, Main.Notes_1, Main.Caller_Name, Main.Division, Main.Territory, Main.Sales_Executive, Main.Referred_SE, Main.Referral_Date, [Referral_Date]+14 AS SE_Response_Due_Date, Main.Inactive_Reason, Main.SE_Notes
FROM Main
GROUP BY Main.Number, Main.[Date of Call], Main.[Prospect Name], Main.[Address 1], Main.[Address 2], Main.City, Main.State, Main.[Zip Code], Main.Phone, Main.[Contact Name], Main.[1st_Class_Volume], Main.[1C_Frequency], Main.Standard_Volume, Main.Standard_Frequency, Main.Flats_Volume, Main.Flats_Frequency, Main.International_Volume, Main.International_Frequency, Main.Currently_Presorting, Main.Presort_Vendor_Name, Main.Notes_1, Main.Caller_Name, Main.Division, Main.Territory, Main.Sales_Executive, Main.Referred_SE, Main.Referral_Date, Main.Inactive_Reason, Main.SE_Notes
HAVING (((Main.Number)>=[Enter Beginning Prospect Number] And (Main.Number)<=[Enter Ending Prospect Number]))
ORDER BY Main.Number;

I do see the GROUP BY phrase, which I believe is the result of my attempt to calculate a new field based on another one in the query. I'm basically taking a date that is entered in the form with the field Main.Referral_Date, and adding 14 days to calculate [Referral_Date]+14 AS SE_Response_Due_Date.

I'm very new to Access, so if there is a better way to do this that will solve my Memo truncation problem, please let me know.

 

[dhookom]

Have you tried removing the GROUP BY? The Referral_Date+14 won't have any affect on this calculation.

Duane
MS Access MVP

 

[Knish89]

Do you mean deleting the just the phrase &quot;GROUP BY&quot; or the entire section? I assume you mean that I should do this in the SQL view.

 

[dhookom]

All you have to do in design view is to click the sigma (backwards 3) on the tool bar. The same can be done by selecting View|Totals. Uncheck the Totals.

I have no idea how this will affect the number of records returned by your query. You will need to decide if this works or not. If Main.Number is the primary key of your table then you will see virtually no difference in the output.

Duane
MS Access MVP

 

[Knish89]

Well, that seems to have worked and the my query is returning the records that I expect it to.

So, that begs the question, what do the Totals and &quot;GROUP BY&quot; functions do. I'm sure this is a very basic question, but like I said, this is my first Access database. Thanks.

 

[dhookom]

Totals and group bys are very powerfull. If you have a table of baseball Teams, Players, and Salaries you could create a totals query that groups by team and either totals or averages salaries. Or something similar for won-loss records.

GO MN TWINS!

Duane
MS Access MVP

 

[Knish89]

Thanks for all of your help. Everything seems to be working now.