Re: graphical count in reports

On Apr 27, 1:59 am, "Squirrel" <wise...@xxxxxxxxx> wrote:
For the dates query maybe you want something like this:

= #1/5/2007# OR = #3/15/2007#

in order to retrieve records for those two dates.

<bhav...@xxxxxxxxx> wrote in message

news:1177631244.460423.232980@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



I have parameter que ry with auto Rpt Tabular, when i give parameter
like 1/5/2007 & 3/15/2007 it shows me all the records including 2006 i
have test box in detail section where control source is
=iif([cr_Status]="completed",1,0) again it doesnt work .
I want query to show me only those record for the date i specify &
also i wanr the status field in report i want it to show me in the end
Completed 100, Cancelled 50, discontinued 25, in progress 200 it
should show me the records & the count .- Hide quoted text -

- Show quoted text -

it should me records between 1/5/2007 & 3/15/2007 and report footer
the count of records howmany cancelled or in process

.