Too many fields!

[upplepop]

I have a form that I need to base on a query with over 120 columns. However, the query does not run becase there are "Too many fields defined". Is there any way to work around Access' limitation to the number of columns in a query?

 

[accessgoat]

I have received the same error message but when I tried to do a union query. The reason is that Access limits the number of columns to 255. I checked out the MSDN Knowledge Base and found a couple of articles on it (but it didnt help me). Anyway myysolution was to do an append query instead. So in your situation you may have to either do a join query or an append query to limit the internal column number.
Hope this helps.

accessgoat.

 

[magezi]

You have no option my dear I had a similar experince and what you have to do is to look at the report you are trying to generate fropm the Query (I think you are creating it for that purpose) If you can create calculated fields on the report to substitute for the fields that could otherwise come from tables then do that Otherwise access is yet to graduate from this limitation. Nkabirwa Sowed Magezi
nkabirwa@yahoo.com

A Ugandan Developer for

(1) School Management Information System(SMIS) - Foxpro 2.6 ; Ms-Acess 97

(2)Debt onitoring System(DMS) - Ms-Acess 97

(3) The Loans Recovery System(LS) - Ms- Access 97

(4) The Dry Cleaners System(DS) - Ms- Access 97