Re: Max # of fields in a query?

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

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 01/02/05 

Date: Sun, 02 Jan 2005 00:21:08 -0700

On Sun, 02 Jan 2005 00:54:41 GMT, "Suzanne Knapp"
<sc.knapp@verizon.net> wrote:

>I don't need all of these
>fields in any one form, but it's simpler to have only one query as the forms
>are being developed.

255... and it's NOT simpler. Such a multitable query will almost
surely be non-updateable and will not support form/subform
arrangements. I'd go the opposite direction: a separate query, as
simple as possible, for each Form.

                  John W. Vinson[MVP]

Relevant Pages

  • Re: Data type mismatch in criteria expression. (Error 3464)
    ... Unmatched Query causing the problem. ... being converted to a number type and then you compare it to ... arrangements, especially where the field can be Null in some ...
    (microsoft.public.access.formscoding)
  • Re: Criteria Row
    ... I run a separate query to extract the records with all zero to generate ... I have no problem getting this query to work. ...
    (microsoft.public.access.queries)
  • RE: Reports Grouping
    ... You stated "So I created a separate query displaying the sums for each group ... Subtotals: 14 ...
    (microsoft.public.access.reports)
  • Relationships and reporting using dates
    ... I have a db with 4 tables, Demonstrations, Expenses, Receipts, and Mileage. ... I already know how to make a query for *each table* that pulls up by date. ... What I cannot seem to do is create the query that doesn't repeat records ... I drag and dropped each separate query onto the report ...
    (microsoft.public.access.reports)
  • Rolling up the days work
    ... I have a db with 4 tables, Demonstrations, Expenses, Receipts, and Mileage. ... I already know how to make a query for each table that pulls up by date. ... What I cannot seem to do is create the query that doesn't repeat records ... I drag and dropped each separate query onto the report ...
    (microsoft.public.access.queries)