Re: Query with too many fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Task Listing New - Print Specs 100 fields
Maybe your tables could be organized in a different manner.
Are you using a separate field for each specification?
Post examples your tables and sample of data. Someone may have a suggestion
to revise to a workable solution.

"Task Database Nightmare" wrote:

If I create a form, how do I use multiple tables in a form so that the tables
are updated so I can create custom queries from the tables as I am also using
a switchboard.

"Douglas J. Steele" wrote:

There's no way to increase the number of fields in a query to more than 255
regardless how many hoops you may go through.

Is there some way that you can use a form and subform (or subforms) to do
your updates?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Task Database Nightmare" <TaskDatabaseNightmare@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:2B6488C9-3CCC-471C-8AAD-2A39C6390ADC@xxxxxxxxxxxxxxxx
Need your help.

I am trying to create a query using 4 different tables. When I try to
create, I get the "too many fields" error message. I tried to trick it by
creating a query with 2 tables then creating another query adding a third
table, etc. but get the same error message. There is only 1 duplicate
field
in each table and yes all fields are necessary. Suggestions?

Tables are as follows:

Task Listing New - Main 62 fields
Task Listing New - Print Specs 100 fields
Task Listing New - Reorder 29 fields
Task Listing New - RFC 126 fields

From the query I am creating a form. Actually I already created the form
and
was using one large table but had to add some fields and received the same
error message so my idea was to break the large table into the 4 tables
mentioned above and then create a query from which the form runs... but
now I
am stuck again.



.

Relevant Pages

  • Re: Unexplained label behavior
    ... After the error message box was closed the values appeared as expected. ... What I don't understand about the problem being timing is that this subform ... I decided to create a Summary Query and used the Count and Sum values to ... So I added 2 labels to the subform, ...
    (microsoft.public.access.formscoding)
  • Re: Query with too many fields
    ... I am trying to create a query using 4 different tables. ... I get the "too many fields" error message. ... Task Listing New - Print Specs 100 fields ... table of PrintSpecs, and third table with a field for the ProductID or ...
    (microsoft.public.access.queries)
  • Re: Query with too many fields
    ... I am trying to create a query using 4 different tables. ... I get the "too many fields" error message. ... Task Listing New - Print Specs 100 fields ... table of PrintSpecs, and third table with a field for the ProductID or ...
    (microsoft.public.access.queries)
  • Query with too many fields
    ... I am trying to create a query using 4 different tables. ... I get the "too many fields" error message. ... Task Listing New - Print Specs 100 fields ... am stuck again. ...
    (microsoft.public.access.queries)
  • Re: Apply filter problem
    ... The error message I get is: ... The subform is bound to a query. ... I'm having trouble with the syntax for applying a filter to a subform, ...
    (microsoft.public.access.forms)