Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Maximum amount of query fields
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access courses - Maximum amount of query fields
Resolved · Low Priority · Version Standard
Reply Mon 9 Jul 2007, 17:05Delegate Tristan said...
Tristan has attended:
Access Intermediate course
Maximum amount of query fields
Hi,
I'm trying to create a fairly large query and require quite a lot of fields to come out of it.
It seems like the maximum amount is 16, is there anyway that I could have more available to use?
Cheers!
Tristan
For upcoming training course dates see: Pricing & availability
RE: Maximum amount of query fields
Tristan
According to Microsoft Access Specifications, Queries have the following specifications:
The max number of fields in a recordset of a query is 255, with a max of 32 tables.
Although you can see only 16 fields, in the Query view, you can keep dragging field names and dropping them in the blank area at the end.
Regards
Carlos
Reply Tue 17 Jul 2007, 15:57Delegate Tristan said...
RE: Maximum amount of query fields
Ahh... perfect! Easy fix that one :)
|