Limit To Query

[tpearo]

Does anyone know if there is a limit to the amount of fields you can query? I have a query that looks at two tables that have alot of data in them. I need the query to create a report. So I have 130 fields in the query. Then I noticed I left about 15 fields out so when I went to add them the query stopped working.

So I am ending up having to split the query into a couple queries and use subreports on the main report. This will work but I was just wondering if anyone knows the limit to the amount of fields that can be in a query.

Tp

 

[alvechurchdata]

wondering if anyone knows the limit to the amount of fields that can be in a query

I think there's a 512 character limit on the length of an SQL statement - but I can't find it in Help.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[dhookom]

You can have only 255 columns in both tables and queries. There is also a limit to the number of characters returned in a row/record of 2000.

Press F1 and search on "Specifications" to find out more.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]