Memo Field

[Guest]

I am using Access 97. in my database. I have a field called Reason Code
which is a combo text field. I need to do a count on this field which I have
already done, by adding a totals field and using count to count the numbe of
fields. which works. But I need to add two more fields to this query which
are in memo type. So it will not let me run the query with this fields being
in memo. I need to use this query to run a report.with all the fields in is
their any way I can do this.

 

[Guest]

Try using Left([YourMemoField], 250) instead of the field.

 

[Guest]

Thanks for that it has worked

Try using Left([YourMemoField], 250) instead of the field.

I am using Access 97. in my database. I have a field called Reason Code
which is a combo text field. I need to do a count on this field which I have
already done, by adding a totals field and using count to count the numbe of
fields. which works. But I need to add two more fields to this query which
are in memo type. So it will not let me run the query with this fields being
in memo. I need to use this query to run a report.with all the fields in is
their any way I can do this.