Double Counting the Same Saturday in a Month...

[Tomfernandez1]

Seasons Greetings:



I have a report with a text box containing this expression: ="Total Saturday Trips =" & Sum(IIf([Rday]="sat",[TOTAL_PASSENGERS],0))

The problem is the expression gives me the sum of each record that contains a saturday date; If 3 records have the same Saturday date, the text box would report 3 Saturdays. I really need it to report one Saturday per date; That is, if I have 3 three records that have 12/18/13, I need the text box to show 1 Saturday only.

Sorry if this is long-winded.. Any help or direction is much appreciated!

-Tommy

[June7]

What section is that expression calculated in? Maybe hide that textbox then in another:

=IIf([other textbox]>0,1,0)

Or

Build an aggregate (GROUP BY) Totals query that groups by date and has the same filter criteria as the main report

Options for using that query:

1. source for a DCount expression in textbox

2. subreport for the summary data

[Tomfernandez1]

I will give it a try, June7.

Thanks for the response and have a Merry Christmas!

-Tommy

[June7]

Ooops, I was editing while you posted. Review again.

Happy Holidays!

[Tomfernandez1]

June7,

All is working fine now!

Thanks again for the assistance!!

-Tommy