Jump to content

Tricky conecept, can it be done?


gorgon2k

Recommended Posts

OK here's what i need to do. I have a table of tickets for a tech company. they want a report that shows how many ticket each tech has in order of most to least. so say there's 12 tech. the query(s) need to be able to take each individual tech, output their amount of tickets and sort them in order of most tickets. how would I go about this. Any idea?

Link to comment
Share on other sites

dan, thanks for the help. It seems that you have two seperate tables in your query.. all this info is contained in one...

 

it's structured like

 

Name

Ticket Id

Bob D

98678

Bob D

43256

Bob D

534534

Jim B

098098

Jim B

654675465

Mike T

5345gfd

 

 

So basically i'd need to get an output like

 

Bob D

3

Jim B

2

Mike T

1

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.