Crosstab query needs to report a memo field

[NeilT123]

Does anyone know if there is anyway to get the equivalent of a crosstab query but with the results showing memo fields.

I can do exactly what I want except that the VALUE I want reported is a memo field and so isn't available as a selection.

Is there an equivalent to a crosstab that will report memo fields?

Thank you in advance for any help.

 

[alvechurchdata]

Might not be suitable for your application but I do this by selecting the leftmost 100 characters of the memo field (followed by "...") so that the user can get an idea of what's there. If they need to read the full memo field then they double-click and I display it in a popup.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[dhookom]

There are some crosstab report samples at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

that use subreports and other methods that might get you around the limit.

If you can live with 255 characters or less the use Geoff's solution.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[NeilT123]

Thank you both for the pointers. I managed to sort the issue by splitting the query into 2