Can I add more than 16 fields to a query

[meadt]

Hi Guys,

I need to create a query that has more than 16 fields, but I cant find an option to insert additional fields. Can you have more than 16 fields, and if so, how?

Cheers,

T

 

[DCrake]

Just sit on a column and press the insert key.

 

[meadt]

Ive tried that, I'm in design mode I right click on a column, but theres no option to insert another column.

 

[meadt]

Sorry DCrake, Just found it. Thanks for your help!

 

[gemma-the-husky]

you need to do this for calculated fields - but if you want to pull more fields down from the tables, just do so - access will expand the grid as necessary anyway.