maximum number of fields in a query

[dbh139]

Is there a maximum number of fields allowed in a single query? How do you add in another field?

 

[Dugantrain]

I would think there's a limit, probably 255. If you're using even a quarter of this many columns, then you probably have your table structure wrong (i.e. displaying what should be records as fields and/or vice versa). Adding in another field? You mean a field that is not in the underlying table? This is possible and, in fact, highly useful (especially when performing calculations), but I'm not exactly sure what you're asking.

 

[texasalynn]

If you're talking about in query design you don't have any more blank fields to bring in another field? If so then just go up to the menu bar and click on insert, then select column. That will add in another blank field

HTH
texasalynn