too many fields defined

[Denjuan]

I got the message: 'Too many fields defined' When i want to run a query from three tables. It will be around 400 columns.
Does anybody know how much columns Access can handle? And is there a way (SQL Server??? Oracle???) or something else to have them all in one table?

thanks already,

Denjuan

 

[DJN]

I think the limit is 255 fields. Can you not run a couple or three queries to gather the data you require, then run a query based on the other queries?

 

[Denjuan]

It has a lot of numbers and percentages in it for a lot of stores. It is a lot, but for my front end i am making now I have to put it in one table.