--- 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 >
Create a New Query that contains and all the fields you need from Both tables. Save this new Query and then write your Crosstab. Give an Example.
