Out of Fields in my query - how to add more???

  • Thread starter Thread starter PaulHilgeman
  • Start date Start date
P

PaulHilgeman

I have a query that needs to multiply QTY * PRICE and QTY * PAY for 10
line items. I was putting in all of the fields and their formulas when
I ran out of fields. How do I add more.

This is a standard Select Query.

Thanks,
Paul
 
Dear Paul:

Are you exceeding 255 columns?

You talk about these being "line items". Are they in different lines (rows)
in the query?

What is the purpose of this query? It is hard to imagine you would expect
to be able to view more than 200 columns on the screen, and it won't fit on
paper for any printer for which I'm familiar.

A bit of information on the structure of your data, the purpose of the
query, and how you expect to use it, all these would be useful in trying to
be of any assistance.

Tom Ellison
 
Save and close the query. Re-open the query.

Or,

Double click on one of the fields of one of the source tables.
The field will be added correctly. If you need a calculated
value, add any field, then change it.

(david)
 
If you are using the query grid to build the query.
--Select Insert: Columns from the menu

The grid shows only a limited number of columns to start with. You can have up
to 255 columns in a query.
 
Back
Top