Results 1 to 3 of 3
  1. #1
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328

    On form, header, show Total and Count of two columns

    I am using Access 2007. I have form where the user selects two dates. The form filters data for sale records between the two selected dates. I have two fields, Total and Owner in the form header. Total=Sum([price]) and count is Count =Count([price]). When the user selects 2 dates and presses Enter, the two fields stay blank. If he then clicks on either field, the two then display Price and Count.



    How can I get the count and price to display after I select the two dates and press the Enter key? Any help much appreciated.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,423
    Exactly how are you applying filter? I cannot replicate issue. If you want to provide db for analysis, follow instructions at bottom of my post.
    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
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    Quote Originally Posted by June7 View Post
    Exactly how are you applying filter? I cannot replicate issue. If you want to provide db for analysis, follow instructions at bottom of my post.
    I was running late and had to issue it. I changed things and installed a filter button rather than filter when update last date. I would still like to know how to do it and will answer your post later in week. Thanks for quick reply.

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

Similar Threads

  1. Replies: 13
    Last Post: 02-16-2021, 07:05 PM
  2. Replies: 3
    Last Post: 01-13-2020, 10:04 PM
  3. Replies: 7
    Last Post: 06-25-2015, 01:03 PM
  4. Replies: 1
    Last Post: 04-06-2014, 10:58 AM
  5. Replies: 1
    Last Post: 01-24-2011, 03:03 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