Concatenate

[Lee-Anne Waters via AccessMonster.com]

Hi,

hoping someone can help...

i have a query that concatenates the the data from two other fields in the
query.

the problem i have having is that it at times does not concat all the
characters. perhaps the filed is only limited to 250 characters.

is there a way to set this concat field in my query to say 'Memo' to allow
for this..

any help appreciated..

thanks
Lee-Anne

 

[Rick Brandt]

Hi,

hoping someone can help...

i have a query that concatenates the the data from two other fields
in the query.

the problem i have having is that it at times does not concat all the
characters. perhaps the filed is only limited to 250 characters.

is there a way to set this concat field in my query to say 'Memo' to
allow for this..

any help appreciated..

thanks
Lee-Anne

It's not the field that is imposing the limit. Are you using Group By or
DISTINCT in the query?

 

[Lee-Anne Waters via AccessMonster.com]

yes i am using a group by..

why would that be a problem?

thanks for your help

Lee-Anne

 

[Rick Brandt]

yes i am using a group by..

why would that be a problem?

thanks for your help

Lee-Anne

Any field in the query with Group By under it will be truncated at 255
characters.

Access 97 and older would have simply given you an error and not allowed you to
put a Group By on that field (then you would at least have been aware of the
issue). Starting with Access 2000 they just automatically truncate the data at
255 characters and group on that value.

 

[Lee-Anne Waters via AccessMonster.com]

thanks for that..

i have re-thinked what i am trying to do and no longer have the group by.
this is now working fine

thanks again
Lee-Anne