Count of replies to main topic

[Nilgni]

I have an MS Access database and ASP. I want to display the number of comments left by users in regard to the current topic.

I was able to get the number to display by joining tables and grouping by count. The issue is that the text in the main topic was truncated. About 1/3 of the text stored in the record for that field was displayed. If I display same record from the table and not the query there is no problem. Through further testing, I realize that it specifically has to do with grouping.

Ultimately I am searching for a way to do it by nesting it inside the original repeat region. Is there a way to build a count and then tell the table row to assign the count by the related field in the master? If not, is there a way to force the entire text field to show? I found something about it being limited to 64K? Is that true?

Thanks, Keith

Here is a link to the page:

http://www.team-amn.com

 

[ChrisHirst]

I found something about it being limited to 64K? Is that true?

Given the lack of information on your table structure and queries it's impossible to say one way or another.





Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.