SELECT count(applicantID) from YourTableName where result = 'no sale' that should do it.
> -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Phil Simon > Sent: Tuesday, October 11, 2005 1:12 PM > To: [email protected] > Subject: [AccessDevelopers] ranking question > > 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 > > > > > > > > > ------------------------ 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/
