I was wondering if someone could help me out. What would be the best way for me to go about determining the sale number from the following table:
applicantID calltime result 1 1/5/05 no sale 1 1/15/05 no sale 1 1/25/05 sale 1 1/26/05 no sale 12 1/5/05 no sale 12 1/15/05 no sale 12 1/16/05 no sale 12 1/25/05 sale 12 1/26/05 no sale the resulting query would provide: applicantID saleattempt 1 3 12 4 etc. Ultimately, I am trying to figure out how many attempts needed to make a sale. Thank you... ps ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
