Search results

  1. S

    Summarizing a table based on a list of values

    Thanks! I appreciate it!
  2. S

    Summarizing a table based on a list of values

    It's a huge DB so I just extracted the two tables in question and put them in the attached DB. Thanks! -Solo
  3. S

    Summarizing a table based on a list of values

    Actually, I don't want a Total of the issues, I need to have a complete list of all IssueID's but with only one IAVerification per IssueID. Each IssueID can have multiple IAVerifications associated with it. But the results table needs to only show one IAVerification value based on the preference...
  4. S

    Summarizing a table based on a list of values

    Hi everyone, I have a two tables with a one-to-many relationship between them. Table 1: tblIssues IssueID (Primary Key – Autonumber) Table 2: tblSubIssues IssueID (FK from tblIssues) IAVerification (Value list - "Verified";"Not Yet Verified";"In Progress";"Passed";"N/A") One IssueID can have...
Back
Top Bottom