I wrote a query, ran it without the count query added, but when I added the total field the datasheet suddenly had symbols in two of the columns instead of the data. I am trying to see all the patients that have had a non face to face encounter (already determined in a earlier query), their specific info some of the status indicators and then the number of encounters that they had (each line would be an encounter in the datasheeet prior to the count being added). If this does not make since please let me know
SELECT [NCM_non face to face].person_nbr, [NCM_non face to face].last_name, [NCM_non face to face].first_name, [NCM_non face to face].date_of_birth, [NCM_non face to face].intervention_type, [NCM_non face to face].intervention_date, [NCM_non face to face].LastOfinsurance1, [NCM_non face to face].LastOfinsurance2, [NCM_non face to face].LastOfexclude_from_reporting, [NCM_non face to face].LastOfPCP_DBP, [NCM_non face to face].description, [NCM_non face to face].expired_ind, [NCM_non face to face].expired_date, Count([NCM_non face to face].person_nbr) AS CountOfperson_nbr
FROM [NCM_non face to face]
GROUP BY [NCM_non face to face].person_nbr, [NCM_non face to face].last_name, [NCM_non face to face].first_name, [NCM_non face to face].date_of_birth, [NCM_non face to face].intervention_type, [NCM_non face to face].intervention_date, [NCM_non face to face].LastOfinsurance1, [NCM_non face to face].LastOfinsurance2, [NCM_non face to face].LastOfexclude_from_reporting, [NCM_non face to face].LastOfPCP_DBP, [NCM_non face to face].description, [NCM_non face to face].expired_ind, [NCM_non face to face].expired_date;
thank you for assisting
Patty
Posted by: pattykf@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar