Concatenate

  • Thread starter Thread starter Lee-Anne Waters via AccessMonster.com
  • Start date Start date
L

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
 
Lee-Anne Waters via AccessMonster.com said:
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
Click to expand...

It's not the field that is imposing the limit. Are you using Group By or
DISTINCT in the query?
 
yes i am using a group by..

why would that be a problem?

thanks for your help

Lee-Anne
 
Lee-Anne Waters via AccessMonster.com said:
yes i am using a group by..

why would that be a problem?

thanks for your help

Lee-Anne
Click to expand...

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.
 
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
 
Back
Top