Terri Jarus
jarus at amerinet-gpo.com
Mon Feb 7 06:28:33 CST 2005
Not sure I fully understand. I've set up the crosstab query which now has the proper field headings - but how do I get the memo fields associated with the correct fields/headings? Terri Jarus Vice President, Contract Services jarus at amerinet-gpo.com 314-542-1902 >>> andy at minstersystems.co.uk 2/7/2005 1:30:16 AM >>> Terri Borge's answer sounds right to me, but if that doesn't work for you I could write you some DAO code if you want. It'll be difficult though for me to fit it in so please only ask if Borge's approach doesn't suit. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Borge Hansen > Sent: 07 February 2005 01:47 > To: Access Developers discussion and problem solving > Subject: Re: [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 > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------------------------------------------------- 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.