that worked, it now counts, the people correctly
thank you so much
Patty
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
What happens if you remove the timestamp column?
Duane Hookom, MVP
MS Access
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 20 Aug 2015 10:04:55 -0700
Subject: [MS_AccessPros] error in query - not counting correctly
I thought I got this right but it is not counting the person_id category
It returns them each on a different row instead of returning them with one row and the number of times they repeated. I must have something wrong, just can't seem to find it
thank you
SELECT CRC_screening_pt_reminder_at_visit.person_id, Count(CRC_screening_pt_reminder_at_visit.person_id) AS ReminderCount, CRC_screening_pt_reminder_at_visit.modify_timestamp, CRC_screening_pt_reminder_at_visit.colon_cancer
FROM CRC_screening_pt_reminder_at_visit
GROUP BY CRC_screening_pt_reminder_at_visit.person_id, CRC_screening_pt_reminder_at_visit.modify_timestamp, CRC_screening_pt_reminder_at_visit.colon_cancer;
Patty
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 20 Aug 2015 10:04:55 -0700
Subject: [MS_AccessPros] error in query - not counting correctly
I thought I got this right but it is not counting the person_id category
It returns them each on a different row instead of returning them with one row and the number of times they repeated. I must have something wrong, just can't seem to find it
thank you
SELECT CRC_screening_pt_reminder_at_visit.person_id, Count(CRC_screening_pt_reminder_at_visit.person_id) AS ReminderCount, CRC_screening_pt_reminder_at_visit.modify_timestamp, CRC_screening_pt_reminder_at_visit.colon_cancer
FROM CRC_screening_pt_reminder_at_visit
GROUP BY CRC_screening_pt_reminder_at_visit.person_id, CRC_screening_pt_reminder_at_visit.modify_timestamp, CRC_screening_pt_reminder_at_visit.colon_cancer;
Patty
__._,_.___
Posted by: pattykf@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar