void CDbtestView::OnHelpdeskViewallcalls() { // Retrieve all records m_pSet->Close(); m_pSet->Open(CRecordset::dynaset,"SELECT [LastName], [FirstName] FROM people; "); UpdateData(FALSE); } void CDbtestView::OnHelpdeskViewunresolvedcallsonly() { // Retrieve only those records where Resolved was not checked (yes/no field) m_pSet->Close(); m_pSet->Open(CRecordset::dynaset,"SELECT [LastName], [FirstName] FROM people WHERE NOT(Resolved); "); UpdateData(FALSE); }