query problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

this is an exapmple from my database:
1 program which has 3 support issues for which several timecards (hours)
have been filed for a total of 5 hours.

query one shows (two columns):
per program the total spend hours on all support issues. I get the following:
example: program a 5 hours

query two shows (also two columns)
per program the total number of support issues. I get the following:
exapmpl: program a 3 issues.


the problem comes when I want one query with the number of issues and the
hours per program, I get the following:

program a 5 hours 6 isssues.

Where do the 6 issues come from?
 
I realized that the total hours (5) is filed using 6 timecards.
but why would this number show as the number of issues when both the issues
and hours are combined in one query?
 
Back
Top