A
Alex
Hi All,
I have a very slow report because I’m using dcount() for every individual
item on this report.
I would appreciate if somebody could advise some other way of doing this
report.
I have a base query with a ‘to do list’:
I have a very slow report because I’m using dcount() for every individual
item on this report.
I would appreciate if somebody could advise some other way of doing this
report.
I have a base query with a ‘to do list’:
Code:
: To Do item Code
[Responsible]: Name
[Completion Date]: dates such as 1/31/2009
[Completed]: Yes, NULL (Empty), ‘N/A’
[ToDoGroup]: ToDoList groups
I need to build a report that would show a % of completion per month and for
the year for items, groups, and totals.
On a report I’m trying to use the following text boxes for each month and
totals to show the result:
On the Code Header (I’m not using details at all):
AugNA:
=DCount("Completed","qryQuery","Completed='N/A' And Code=[txtCode] And
[Completion Date] between #08/1/2008# AND #08/31/2008#")
AugNo:
=DCount("Completed","qryQuery","Completed='No' And Code=[txtCode] And
[Completion Date] between #08/1/2008# AND #08/31/2008#")
AugAll:
=DCount("*","qryQuery ","Code=[txtCode] And [Completion Date] between
#08/1/2008# AND #08/31/2008#")
AugYes:
=DCount("Completed"," qryQuery ","Completed='Yes' And Code=[txtCode] And
[Completion Date] between #08/1/2008# AND #08/31/2008#")
Aug:
=IIf(([AugAll]-[AugNA])=0,"",[AugYes]/([AugAll]-[AugNA]))
The same in the ToDoGroup footer but adding And [ToDoGroup]=[txtToDoGroup]
to a condition in dcount()
The same formula used for Totals but without conditions for [Code] and
[ToDoGroup].
All numbers on a report are correct but it’s just extremely slow.
Thanks