Jordan, Yes, you can. You will need to create a query with all of the required data fields.
Merrick ----- Original Message ---- From: njdave71 <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, November 21, 2007 3:23:56 PM Subject: [Access VBA Central] Re: combining fields --- In AccessVBACentral@ yahoogroups. com, "scolbertrocks" <computergeek198@ ...> 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. ____________________________________________________________________________________ Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ [Non-text portions of this message have been removed]
