I am sorry if this topic is tired, but after all that I have read I am
still in the woods here. I have built a database to handle weekly and
monthly reports of what people are doing. They submit what they are
working on and then you input a date and the info is narrowed allowing
a report to be created containing all of the memo fields submitted
during those dates. My Source Query gets all the memo fields in their
entirety (greater than 255 chars), and then a Union Query puts the data
in a format that is easy to read i.e.:
Header A
User 1's Entry
User 3's Entry
Header B
User 1's Entry
User 2's Entry
User 4's Entry.....
The union query cuts off the fields at 255 characters. From previous
experience does this look like it is easy to solve. Here is some of
the SQL if that helps.
SELECT "a _GENERAL ITEMS" as Category, [General Items] as Item from
[Mk 36 01Jan Source] UNION
Select "c _OPN FUNDING", [Blank Space] FROM [Mk 36 01Jan Source]
UNION
Select "c (5) Procurement", [Procurement_OPN] FROM [Mk 36 01Jan
Source] UNION .....UNION
[Upcoming Events of Notice] FROM [Mk 36 01Jan Source];
Thank you very much for your time,
Jimmy Shaw
NSWC PHD Det Louisville Code G51
502-364-5276
james.shaw2@navy.mil 
