Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2008
    Posts
    101

    Unanswered: Help with Counter on filter results

    Hi i have 2 things i need help again on. i appreciate all what you guys done so far but 2 more things

    first
    I need to sum a total of percentages on a report, how would this be done?

    second
    i have filters running on my form which filter all callbacks between specified intervals i.e. 10-12, 12-2, 2-4 etc you click the relevant button i.e 12-2 and it bring all callback for that time...once someone takes ownership of that callback by inputting a 2 character intitial it gets taken out of the filter results upon next click. is there a way i can see a real time counter of how many records are left after someone takes ownership and it minuses 1 until all records have been cleared from the filter results?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I need to sum a total of percentages on a report, how would this be done?
    There are two ways:

    1. Make sure the percentage calculation is done in the query and then use Sum on that column in the report.
    2. Use the same percentage formula on the other total text boxes in the report itself.

    is there a way i can see a real time counter of how many records are left after someone takes ownership and it minuses 1 until all records have been cleared from the filter results
    I don't fully understand the question here. Sounds ok until I get to "and it minuses 1....".
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Sep 2008
    Posts
    101
    sorry about that was an early start this morning
    yeah a real time counter showing once someone takes ownership of the record it subtracts one off the counter of the results and keeps on counting down until all the filtered results have an owner?
    hope that helps.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Ok, with that you wouldn't need to have anything to minus, you just count the number of records each time, so that would be real time.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Sep 2008
    Posts
    101
    how would that work, would i need a text box and change the control source to count records? how would it be set out ?
    thanks

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Have a look at DCount().
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Sep 2008
    Posts
    101
    So how would the dcount function work?
    as i have 5 buttons each with a different filter for the time specified i.e. 12-2pm,2-4pm,4-6pm,etc when a button is pressed it filters out the specified times and brings back all the records where the customer would like a callback at that time, how would i have a counter next to them showing the amount of records in the results before actually pressing them, i would then be able to see how many callbacks i would have for each interval.
    thanks

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Five different DCounts.

    You should really try the help files etc. They tell you lots about things like DCount.

    DCount("SomeField","SOMETABLE", "SomeCriteria")
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Sep 2008
    Posts
    101
    but how would that count my filter results in a small text box before actually clicking the button? should it dcount the field that the query is based?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •