Query s tmp comfort care gt one

Data Integrity Checks
Summary:	Only one entry allowed per patient.
Related:	Comfort Care
Firmness:	hard check
Timing:	always
App:	CCMDB.accdb
Coding:	query s_tmp_comfort_care_gt_one
Uses L Problem table:	not relevant for this app
Status:	retired
Implementation Date:	not entered
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

Log

• 2023-11-26 - deleted query since it is long defunct. SQL was

SELECT L_TmpV2.Pat_ID, "Pt has more than one comfort care tmp entry." AS Problem
FROM L_TmpV2
WHERE (((L_TmpV2.Project)="Comfort Care"))
GROUP BY L_TmpV2.Pat_ID, "Pt has more than one comfort care tmp entry."
HAVING (((Count(L_TmpV2.Tmp_ID))>1));