Dcount (1 Viewer)

ielamrani

Registered User.
Local time
, 19:57
Joined
May 6, 2008
Messages
51
Hi,

I have this query:

ID Attending Trauma RN Date
1 A No Yes 1/1/12
1 A Yes No 2/1/12
1 B No Yes 1/1/12
1 A Yes No 3/1/12
1 B No Yes 6/1/12

I merged this query into a report to give the count of each attending equaling yes only. I am using this: =DCount("*","qryMainJan-Jun13","[PeripartumHysterectomy] ='Yes' And [Text30] = ID")
the goal is to show each attending on a separate page with count on text box

the issue I am having is I can't show the correcttotal in one page for each attening. for example I am showing attending A twice for trauma with total 1 for each page. I need to show attending A with total 2.

I hope this is not confusing.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 00:57
Joined
Feb 19, 2013
Messages
16,708
Not quite sure what you are trying to do unless PeripartumHysterectomy is the real name for Trauma also what is text30?

The problem is with the construct of your dcount so if text30 is a control on your form or report then the criteria should be

ID=" & text30

If this does not solve your problem you need to explain a bit more about your data and you form/report
 

Users who are viewing this thread

Top Bottom