[AccessD] Help with Code

Terri,
This is what I would try to do:

1. Create the crosstab you need withouth the memo field and save as Query
2. Create another query based on 1. and with the memo field added

Regards,
Borge

----- Original Message ----- 
From: "Terri Jarus" <jarus at amerinet-gpo.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, February 07, 2005 6:41 AM
Subject: [AccessD] Help with Code


> SECOND ATTEMPT (without attached sample file)
> I apologize for not knowing how to do this on my own and appreciate any
> help I can get.  I have a table of data - one field named "Name", a
> second field named "Text" and a third field named "ContractID".
>
> The TEXT field is a memo field.  What I really wanted to do was to
> create a crosstab that has the Contract ID as a row, the Name as a
> Column Heading and the TEXT appearing under the appropriate name.
> However, crosstab won't work with a memo field.
>
> The data under NAME is confined to 23 distinctive items.  For example,
> one would be ACCESS CRITERIA, one would be CONTRACT BENEFITS, etc.  So I
> thought to create a new table with each of the NAME items as a field
> heading. Then writing a row for each Contract ID (another field heading)
> and the assigned TEXT to the appropriate NAME.  Hope that makes sense.
> I just don't know how to write the code to do this.
>
> Small sample data file can be sent on request.  As is always the case,
> I need to get this going ASAP.  Any help or pointing to something
> similar would be greatly appreciated.
>
> You guys rock!
>
> Terri Jarus
> Vice President, Contract Services
> jarus at amerinet-gpo.com
> 314-542-1902
>
> --------------------------------------------------------------------------
-
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individuals or entities to whom they
> are addressed. If you have received this email in error please return
> it to the sender, and erase any copies thereof.
> Copyright 2005 Amerinet 1nc.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>