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.
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
[quoted text clipped - 3 lines]
> 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.
horseman - 09 May 2006 13:03 GMT
Thanks for that it has worked
> Try using Left([YourMemoField], 250) instead of the field.
>
[quoted text clipped - 5 lines]
> > 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.