- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
MS Access Query Question
Posted on 10/29/14 at 12:25 pm
Posted on 10/29/14 at 12:25 pm
I have a table recording phone calls made called Call Log. Each phone call has a result (callResult). A record (PartID) is considered complete when callresult=6. I am trying to write a query that can tell me the average number of calls it takes to complete the record.
Any help? Thanks!
Update: Ok. Figured that out. Was easier than I thought. I was trying to make it way more complicated.
New Issue: There can be more calls after the callresult=6 but I don't want to count them. What can I do?
Any help? Thanks!
Update: Ok. Figured that out. Was easier than I thought. I was trying to make it way more complicated.
New Issue: There can be more calls after the callresult=6 but I don't want to count them. What can I do?
This post was edited on 10/29/14 at 1:29 pm
Posted on 10/29/14 at 1:55 pm to Winkface
Need more info. Do you have date/time column? Does the call result change?
Posted on 10/29/14 at 2:02 pm to Winkface
quote:People still use this? I seriously thought this was discontinued years ago. I'd rather use sqlite.
MS Access
Popular
Back to top
Follow TigerDroppings for LSU Football News