Results 1 to 3 of 3
  1. #1
    TioAdjie is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Feb 2014
    Posts
    16

    Put calculated field on subform


    Dear Access Master,
    I have a subform and I want to calculate total number of records in that subform. Therefore I use domain aggregate Count(*) below subform. Do you think, it is good idea ? I am just worried that it will slow in speed when open the form with that subform inside. If it's slow, do you have other alternative ?
    Because I read on internet tips that DA (domain aggregate) will slow, because it will fetch all records eventhough I just need one value.
    Previous thread I saw that it won't affect the speed in form with VBA code inside the form. What I ask, does it effect by using DA on form ?

    Thanks a lot for your help.
    regards,
    Tio

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Count(*) is not a domain aggregate, it is SQL aggregate.

    Domain aggregates are prefixed with D - DLookup, DSum, DCount etc. - and can be slow on form/report and in queries.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    TioAdjie is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Feb 2014
    Posts
    16
    OK. Thank you very much.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-15-2013, 02:29 AM
  2. Calculated Field on subform
    By nicole.skeeters in forum Forms
    Replies: 8
    Last Post: 07-23-2013, 05:55 PM
  3. Replies: 1
    Last Post: 04-21-2013, 03:20 PM
  4. Replies: 3
    Last Post: 02-13-2013, 10:15 AM
  5. Calculated field help
    By eds in forum Access
    Replies: 2
    Last Post: 07-18-2011, 05:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums