Hi,
i'm not too sure on how to tackle this one, I think its probably easier then i'm making it! All i need to do (i say all),is to create a query which Counts the occurances of an ID in a table. So to carry on the example, the table holds IssueId, issueDesc, issueDate etc...
Each issue has an issue id, and each issue can have several occurances, with the same id. so i need to count these occurances. In my table tblIssueOccurance, it lists all the issues. So how do i count the issueoccurances for each issue?
Hope this makes sense, if not let me know and i'll explain some more, #
Kind regards,
Alex Marchant
i'm not too sure on how to tackle this one, I think its probably easier then i'm making it! All i need to do (i say all),is to create a query which Counts the occurances of an ID in a table. So to carry on the example, the table holds IssueId, issueDesc, issueDate etc...
Each issue has an issue id, and each issue can have several occurances, with the same id. so i need to count these occurances. In my table tblIssueOccurance, it lists all the issues. So how do i count the issueoccurances for each issue?
Hope this makes sense, if not let me know and i'll explain some more, #
Kind regards,
Alex Marchant