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 >
