I have query based on two tables.
Table 1 has the main ticket information
TicketNo, Date, Type, EnteredBy, etc...
Table 2 has the ticket detail
TicketNo, Desc, Code, Amount, etc...
What I am trying to do is count the number of tickets for each code in the "NONBILLABLE" category.
The query I have works, however, in the ticket detail it is counting the ticket for everytime that code shows up. For instance, I could have "Layout Error" on 3 different line items within that ticket, so it will count that ticket 3 times rather than just once.
Any idea on how I can narrow it down to just count it once?
Thanks
Brandy
Table 1 has the main ticket information
TicketNo, Date, Type, EnteredBy, etc...
Table 2 has the ticket detail
TicketNo, Desc, Code, Amount, etc...
What I am trying to do is count the number of tickets for each code in the "NONBILLABLE" category.
The query I have works, however, in the ticket detail it is counting the ticket for everytime that code shows up. For instance, I could have "Layout Error" on 3 different line items within that ticket, so it will count that ticket 3 times rather than just once.
Any idea on how I can narrow it down to just count it once?
Thanks
Brandy
