Re: Q. Is 19 fields too much for a query ?

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

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 03/12/04 

Date: Sat, 13 Mar 2004 07:11:16 +1300

Jim,

To add to Fred's comments, be aware that, depending on various factors
of the structure of the data and the relationships between the tables
(not the number of fields), your query may or may not be "updateable".
So, if the purpose is to display the query's data on a form, this will
be fine, as Fred said. If your intention is to enter/edit data on the
form, this may not be possible. 

-- 
Steve Schapel, Microsoft Access MVP
fredg wrote:
> There shouldn't be any problem making the query or displaying the
> returned data in a form. Make sure that all the relationships are
> correct between the tables.

Relevant Pages

  • Re: Order by not working
    ... Depending on which link I click on it's either ... altering as I've added a line to print the query to the screen to make sure ... All I can say is on one server the data is displayed ... Where on the other server where ORDER BY 'count' could display the order in ...
    (comp.lang.php)
  • IIf Null, then hide
    ... I have a form based on a query that will display one ... Depending on the ... some or all of the textboxes will be ...
    (microsoft.public.access.formscoding)
  • Sending data to access query from Visual .net form
    ... I have made a query called "Schedule",in access using few tables. ... Depending ... the Required date field for my "Schedule" and display the result on the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cobol Myth Busters
    ... ON SIZE ERROR phrase is used. ... access to tables of fixed size, and so should be avoided where high performance is needed. ... 05 depending-element occurs 1 to 4096 depending on binary-number. ... Packed is almost as slow as display. ...
    (comp.lang.cobol)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)