How do you add Columns to the Query design form?

[zachsiue]

Hi,
I am a new access user who is trying to create a query that requires information from many tables. The query is working, but I ran out of columns on the bottom of the design form to tell the query what information to output. (I am talking about the columns that have the rows: Field, Table,Sort, Show, and or.) Is there a way to add more of these columns?

Thanks in advace!!

Zach

 

[Darrylles]

Hi Zach,

You want more fields to be included in your output from the query?

Then move right to the next field - and it's corresponding Table, Sort, Show, and or.

No?

Kind Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[zachsiue]

The amount of data being extracted is so large that I have ran out of places to enter the field name, table name, sort, etc... Do you know of a way to insert additional ones?

Thanks,
Zach

 

[c0i0nes]

In design view the menu item Insert -> Columns adds a column, but what I think you need is Insert -> Row to have another row to fit another 'Or' criterion into. However, in a single row cell you can type:

a or b or c or d

Access will change that to:

"a" or "b" or "c" or "d"

before you run the query.

Another way to do this is to use In()

In(a,b,c,d) is the same as above

 

[JeroenNL]

You could break up your query into seperate queries also. Select everything you need in a query and if you don't have enough columns, create another query which uses the first query as input + all the tables you need to get the other data. Then simply select the asteriks * from the first query to select all fields from that query and continue building the second query. Am I making sense here?

Bye,
Jeroen

 

[gusbrunston]

[tt]
Hi:

"Add a column to the design grid in a query: Click anywhere in the column to the left of which you want to add a new column. On the Insert menu, click Insert Column." from Help, A2K [tt] Gus Brunston - Access2000(DAO)[/tt] Intermediate skills.