yessir
Saved By Grace
- Local time
- Today, 03:13
- Joined
- May 29, 2003
- Messages
- 349
oh, finally I am close to what i need
I have the report in the included db. there are 2 problems though.
1
the subreport DOES sum the total for each outlet if there is one, BUT it includes a row for each outlet, therefore repeating up to 3 times.
ex:
if EN-02 and EN-05 have values 1 and 3 recorded on the same date then the report has the rows:
March 8, 2004 1 0 3
March 8, 2004 1 0 3
when it should only show 1 of the rows
and if there is a value from another date it includes it in this as well.
so how can i have this limited to the sum where the dates are the same.
2
how can I have it display "No flow" if there are no values instead of '0'
thanks for all your help in advance
~
I have the report in the included db. there are 2 problems though.
1
the subreport DOES sum the total for each outlet if there is one, BUT it includes a row for each outlet, therefore repeating up to 3 times.
ex:
if EN-02 and EN-05 have values 1 and 3 recorded on the same date then the report has the rows:
March 8, 2004 1 0 3
March 8, 2004 1 0 3
when it should only show 1 of the rows
and if there is a value from another date it includes it in this as well.
so how can i have this limited to the sum where the dates are the same.
2
how can I have it display "No flow" if there are no values instead of '0'
thanks for all your help in advance
~
