Search results

  1. MrDix

    Count Issue

    Hi, I am using the code below to get the right count of Cases (records) for each agent. SELECT tblCase.Agent, Count(*) AS pkCaseID FROM tblCase GROUP BY tblCase.Agent; it works fine: I have 8 Cases (records) My results are: Eric = 2 Luis = 2 Carlos = 1 Tammy = 1 Nancy = 2 Now, My Issues is...
  2. MrDix

    DCount Issue??

    Hi - I am having an issue with the Dcount funtion on my report. I have a report base on two tables: tblCustomer and tbl Cases I have the following on my Report Footer: Customer: =Count([pkCustomerID]) Case: =Count([pkcaseID]) My problem I come out is: Customer = 5 Cases = 5 The Cases Total...
  3. MrDix

    AutoFill Data

    Hello, I am creating a helpdesk support database. My question is for my Customer Form. As I tested the form I realized that one of my Combo Boxes may not work cause the name may not be the same when the customer calls. Let me Explain: The Combo Box is query from one table with 5 Fields...
    • MrDix
    • Thread
    • Replies: 0
    • Forum: Forms
  4. MrDix

    Table Design and Relationship and Data Form

    First of all, I want to say Thank you to everyone in this forum I have been reading just about every question in each Topic and I have pick up a lot more than I tough I knew. [Thank you]! I not sure how to ask this question or better yet write it. Here is my Situation I work for the NAVY as an...
Top Bottom