251 Character limit on text filed after 'min of' query

[sparkyrose]

Hi there,

I have a query that is itself based on two other queries. I was getting multiple hits of certain data due to there being a 2008, 2009, 2010 instance of certain records, so I applied a 'Min of' to the date field.

I have a separate text field in the same query which displayed all text prior to the 'min of' but when it's applied Access limits the text to 251 characters when the query is run.

Does this make sense to anyone? If so, what can I do?

Thanks in advance

 

[Remou]

This is a known problem:

http://allenbrowne.com/ser-63.html

Is it possible for you to use another method of displaying the text field, DlookUp on a form or report, for example?

 

[sparkyrose]

Thanks for the reply.

I'll see if I can get that to work

 

[MikeC14081972]

I have had this problem and got round it using first

i.e.

SELECT first(tbl_Table.Field) FROM tbl_Table

Hope that helps