query cannot retrieve enough fields

[complexx]

I'm trying to build a form based on a query to use for data editing/entry purposes.

The only way I can think of to do this is to use a query to get data that is particular to my specified customer.

The first problem I have run into is that one query does not contain enough fields to retreive all the fields in my table.

I figure, perhaps I have made a flaw in my design and shouldn't go further with this until I verify it to be true. I don't think I've made a flaw, but the fact that a query has limited maximum number of fields leads me to think I might have.

Each record in the table I'm querying contains several pieces of numerical data that might be recorded during a service visit.

Obviously I could query the table twice but that doesn't feel like the right way to go about it.

 

[Moniker]

A query is based on a table, and a table has a limit of 255 fields. If you're hitting that limit, you definitely have some design issues.

 

[complexx]

Oh is that bad? j/k

I'm using Access 2003. When I open a query in design view, there are 15 fields that I can specify. I'm not trying to query 255 fields, more like 20 or 25. How do I enable more fields to use?

*Edited for comic value.

 

[KeithG]

goto Insert=> Columns