query problem

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?
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top