ok, thank-you
-----Original Message----- From: mswatchorn <[EMAIL PROTECTED]> To: [email protected] Sent: Tue, 20 Nov 2007 3:01 pm Subject: [Access VBA Central] Re: combining fields Jordan, The first step is to create a SQL statement that concantenates the two fields together then, create the crosstab query. Merrick --- In [email protected], "scolbertrocks" <[EMAIL PROTECTED]> wrote: > > hey > i was wondering if there was anyway that i could combine 2 fields that > are in seperate tables and then use them together as a single field in > the column headings of a crosstab query > > for example: > i have a field in a table for lawnmowers and a field in a different > table for rakes. I want to make a crosstab query that has all my > lawnmower entries and all my rake entries as column headings. > > hope i didnt make it too complicated... > thanx, > jordan > ________________________________________________________________________ Check Out the new free AIM(R) Mail -- Unlimited storage and industry-leading spam and email virus protection. [Non-text portions of this message have been removed]
