FN-FORUM: SQL / programming Q

date posted 3rd October 2006 17:49

Hi

I'm a bit lost on how to approach a page. I want to display a list of
surveys that will be taken and alongside each survey I want to show
how many of the (invited) users have completed the survey. So it
would be a list like:

Group / Survey Name (4 completed, 38 pending)

Etc=85

I store the surveys in tblGroups and the list of invited users in
tblResults. A field in the latter called SubmittedDate stores the
date a user completed the survey, so if this is blank I know they
still haven't taken the survey.

This is the data structure:

tblGroups
GroupID
GroupName

tblResults
GroupID (FK to above)
ClientID (stores the invited user)
SubmittedDate

Any help would be greatly appreciated.
TIA
Paul