Limit to number of calculated fields in a query? 1

[VBAjedi]

This has probably been asked before, but I can't seem to find it.

How many calculated fields can you have in a query?

I have created a query that seems to limit me to 16 fields (all but one are calculated fields). Surely this is not the limit? The query is based on a simple two-table join, and all of the calculations are simple arithmetic operations on various fields from the two tables.

I say it seems to limit me to 16 because it only displays 16 columns in the Design Query window. I can scroll past the 16th column to the right but it's just gray background.

VBAjedi

 

[RoyVidar]

I can't seem to remember using queries with that many calculated columns, but did you try the Insert menu (Insert | Columns).

Roy-Vidar

 

[VBAjedi]

I need a break. That was all it took! Looks like Access just provides you with 16 columns by default when you create a query from scratch. You just insert more manually if you need them.

I'm used to dbases (i.e. MySQL) automatically adding columns as needed in the design view to stay "one ahead".

Have a star. . . who knows how much time that saved me! [LOL]

VBAjedi