Replies

Hans,

I was hoping the Office XP would fix my issue, but I still have the same problem (truncating the concatinated field to 254 characters).
I know very little about VB or the ‘Jet…’ service packs (?), but I don’t show under tools > references the Jet 4.0 SP6 or Jet 4.0 SP8. Is this
something I need and how do I go by getting it if so? …or do I need to do something else? Please help.

Thanks,
Drew

Thank you very much for the help, but removing the IF statement didn’t work.
I’ve talked to our MIS dept here. After the holidays they are going to set my machine up with Office XP. I’ll let you know if this
works then.

Thanks again,
Drew

Thank you very much for the help, but removing the IF statement didn’t work.
I’ve talked to our MIS dept here. After the holidays they are going to set my machine up with Office XP. I’ll let you know if this
works then.

Thanks again,
Drew

Hans,
I ran the .exe file after downloading, but my query is still truncating.
Am I doing something wrong?

Thanks so much for your help.

Hans,
I ran the .exe file after downloading, but my query is still truncating.
Am I doing something wrong?

Thanks so much for your help.

Hi Hans,

I’m trying to use this same script for another instance but am having a problem. I have an table/qry with 2 columns; one is ID and the other is NOTES (having multiple records of notes per ID).
Below is the statement I’m using and works, but it truncates at around 250 characters? Am setting this up correctly?
NOTES: Concat(“QRY_CONCAT_DESC_NOTES”,”CONCAT”,”[PROB_ID] = ” & [PROB_ID],””,Chr(13) & Chr(10) & Chr(13) & Chr(10))

Regards,
Drew

Hi Hans,

I’m trying to use this same script for another instance but am having a problem. I have an table/qry with 2 columns; one is ID and the other is NOTES (having multiple records of notes per ID).
Below is the statement I’m using and works, but it truncates at around 250 characters? Am setting this up correctly?
NOTES: Concat(“QRY_CONCAT_DESC_NOTES”,”CONCAT”,”[PROB_ID] = ” & [PROB_ID],””,Chr(13) & Chr(10) & Chr(13) & Chr(10))

Regards,
Drew

Works great.
Thanks

Works great.
Thanks

Hans,
Would it be possible to change the expression and use the same code on another query?
I have a table of the following columns…
ID [Number; Long Integer]
ITEM [Text]
MFG [Text]
In this list, the MFG is the field that I would like to combine/concatenate with respect to both ID & ITEM. I’ve tried to
modify the expression that you had given me, but with my knowledge I’m not able to get it to work.
Can you help?
Thanks,
Drew

Hans,
Would it be possible to change the expression and use the same code on another query?
I have a table of the following columns…
ID [Number; Long Integer]
ITEM [Text]
MFG [Text]
In this list, the MFG is the field that I would like to combine/concatenate with respect to both ID & ITEM. I’ve tried to
modify the expression that you had given me, but with my knowledge I’m not able to get it to work.
Can you help?
Thanks,
Drew

It works great!!!
Thank you!

Drew

It works great!!!
Thank you!

Drew

Here is the result…
SELECT [Description] FROM [Concat] WHERE ([Part Number] = 3810001000) ORDER BY [Line Number];

Thanks,
Drew

Here is the result…
SELECT [Description] FROM [Concat] WHERE ([Part Number] = 3810001000) ORDER BY [Line Number];

Thanks,
Drew