Results 1 to 2 of 2
  1. #1
    waqar is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2018
    Posts
    1

    two function in access

    how to use two function together like sum and count in access footer.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    two separate textboxes, one with

    =sum(myField)

    and the other with

    =count(myField)

    where myField is the name of the field in the form recordsource which you are summing or counting

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

Similar Threads

  1. Replies: 2
    Last Post: 02-26-2017, 11:31 AM
  2. Not sure about the function --MS Access
    By mks123 in forum Programming
    Replies: 15
    Last Post: 02-06-2017, 01:52 AM
  3. Access IIf function help
    By drz in forum Access
    Replies: 1
    Last Post: 11-04-2016, 01:29 PM
  4. Using the Nz function (Access 07)
    By jonny3000 in forum Access
    Replies: 5
    Last Post: 11-15-2012, 12:46 PM
  5. function in access
    By ali zaib in forum Access
    Replies: 3
    Last Post: 01-14-2012, 01:09 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