- 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:01 pm to aaronb023
Yes. There is a column for Call Date and Call Time.
Call result has choices from 1 to 6. Examples are "Left a voicemail" or "No voicemail." 6 means they completed the survey. Tricky part is there can be some more calls after completing the survery, for example, quality assurance. I don't want to count those.
Call result has choices from 1 to 6. Examples are "Left a voicemail" or "No voicemail." 6 means they completed the survey. Tricky part is there can be some more calls after completing the survery, for example, quality assurance. I don't want to count those.
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
Posted on 10/29/14 at 2:20 pm to Winkface
Will the follow ups still have a 6 or will that field be blank?
Posted on 10/29/14 at 2:23 pm to aaronb023
They will probably be 1-5. May be blank.
Posted on 10/29/14 at 2:42 pm to Winkface
You will probably need a second query that gives you th unique identifier for the call and the date stamp of Callresult 6.
Left Join that onto your existing count query and exclude everything that comes after the time stamp for call result 6.
Left Join that onto your existing count query and exclude everything that comes after the time stamp for call result 6.
Popular
Back to top
Follow TigerDroppings for LSU Football News