Replies

Thanks

Another question if you don’t mind.
I’m doing a report where I have one table that iskeyed off of ‘ID’. Another table that’s keyed off of ‘ID’ and ‘ITEM’, and another table keyed off of ‘ID’ and ‘DATE’. I make a query with these 3 tables.
What I’m trying to accomplish is making a report (from the query) that list the ‘ID’, then all the ITEMS (multiple) under the ID and in addition have all NOTES under the ID. Is this possible?
I hope I didn’t confuse you with my terrible explaination. Let me know if I did.

Thanks in advance for the help.
Drew

Thanks

Another question if you don’t mind.
I’m doing a report where I have one table that iskeyed off of ‘ID’. Another table that’s keyed off of ‘ID’ and ‘ITEM’, and another table keyed off of ‘ID’ and ‘DATE’. I make a query with these 3 tables.
What I’m trying to accomplish is making a report (from the query) that list the ‘ID’, then all the ITEMS (multiple) under the ID and in addition have all NOTES under the ID. Is this possible?
I hope I didn’t confuse you with my terrible explaination. Let me know if I did.

Thanks in advance for the help.
Drew

That’s weird, this is what I had for line 20 in VB after I copied your code in…
Chr$(n) & lt > Char Then
I should of double checked the code you pasted. Sorry.

I copied, repasted, and everything seems to work perfectly.
Thanks for the help.
Regards,
Drew

That’s weird, this is what I had for line 20 in VB after I copied your code in…
Chr$(n) & lt > Char Then
I should of double checked the code you pasted. Sorry.

I copied, repasted, and everything seems to work perfectly.
Thanks for the help.
Regards,
Drew

The error was a compile error.
I removed the semicolon from line 20 and everything seemed to work right. Is this to be included in the code?

Thanks,
Drew

The error was a compile error.
I removed the semicolon from line 20 and everything seemed to work right. Is this to be included in the code?

Thanks,
Drew

Mark,

I’m getting an error on line 19 and 20 of your code.
Do you get the same?

Thanks,
Drew

Mark,

I’m getting an error on line 19 and 20 of your code.
Do you get the same?

Thanks,
Drew

Thanks for the info.

Thanks,
Drew

Thanks for the info.

Thanks,
Drew

Hans/Wendell,
I did check and did already have SP8 installed, but to ensure I went ahead downloaded and ran the file, which didn’t change anything.
I don’t know why I didn’t think of this earlier, but one thing I didn’t try was setting up a separate table and trying this from scratch. Once I done this, the field was no longer truncated. Something must of happen with my original table????? I’ll just have to copy the text over to the new table.
Thanks for all the help!!!

Regards,
Drew

Hans/Wendell,
I did check and did already have SP8 installed, but to ensure I went ahead downloaded and ran the file, which didn’t change anything.
I don’t know why I didn’t think of this earlier, but one thing I didn’t try was setting up a separate table and trying this from scratch. Once I done this, the field was no longer truncated. Something must of happen with my original table????? I’ll just have to copy the text over to the new table.
Thanks for all the help!!!

Regards,
Drew

Hans,
I just got Windows XP and Office XP installed on my machine, to which I’ve ensured that I have the JET 8.0 SP. Unfortunately I’m still having problems with it truncating. I feel like this is something that I’m doing wrong on my side I’m but not for sure, so below are the fields in my table (TBL_US_EXT_DESC) and their data types…
Part Number — Text
Description — Memo
Line Number — Text

The query I set up only includes the above table, with Part Number being the only field that is grouped on. The Concat statement that I’m using is the following…
Long Desc: Concat(“TBL_US_EXT_DESC”,”Description”,”[Part Number] = ” & Chr(34) & [Part Number] & Chr(34),”Line Number”,Chr(13) & Chr(10))
Total = Expression

Does everything look right? I’m at a loss on what else I can do to possibly fix this problem?
Any help is greatly appreciated.

Thanks,
Drew

Hans,
I just got Windows XP and Office XP installed on my machine, to which I’ve ensured that I have the JET 8.0 SP. Unfortunately I’m still having problems with it truncating. I feel like this is something that I’m doing wrong on my side I’m but not for sure, so below are the fields in my table (TBL_US_EXT_DESC) and their data types…
Part Number — Text
Description — Memo
Line Number — Text

The query I set up only includes the above table, with Part Number being the only field that is grouped on. The Concat statement that I’m using is the following…
Long Desc: Concat(“TBL_US_EXT_DESC”,”Description”,”[Part Number] = ” & Chr(34) & [Part Number] & Chr(34),”Line Number”,Chr(13) & Chr(10))
Total = Expression

Does everything look right? I’m at a loss on what else I can do to possibly fix this problem?
Any help is greatly appreciated.

Thanks,
Drew

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