Finding a Median (1 Viewer)

[Mihail]

When I press that button (Center Sepsis Analysis Report) Access ask me for parameters:
Start Date
End Date
DCSM Center

What I should respond ? Or where to set this entries ?

 

[Mobiusrune]

Start Date use 01-01-2013
End Date use 01-01-2014
DCSM Center use CHMC

 

[Mihail]

Try now and... report

 

[Mobiusrune]

I run the report and it seems to work until I try to look at the second page (where the Stats are) and I get...see attached

 

[Mihail]

Ufff. Seems that now is working.

 

[Mobiusrune]

Okay...Obi Wan...you have a wonderful way with the force...
So what did you do exactly so that I can duplicate it for my other Expr# and my other report. I did not see any change to the report structure or the query...the Parameter request is different though...

 

[Mobiusrune]

Okay...I see the changes to the module. So where exactly was the limiting factor...what is the filter parameters in the query that was throwing a wrench in?

You have been supremely wonderful with this and I cannot thank you enough for the patience and effort.

 

[Mihail]

I have removed all unnecessary request for inputs.
I keep only the inputs from the main query.
Sorry, but is not easy to explain even if I use the Romanian language.
If I can show you in time I explain....

I'm afraid that I have missing something. Run again the report and tell me if you see the Start Date end the End Date in top of your report.

 

[Mihail]

And it is not about the field name. The Expr1 name is as good as anything else (LightSword is better ).

 

[Mobiusrune]

No to and from dates at the top...just blank spaces.

 

[Mihail]

Type yourself in that textboxes (or in their Control Sources) this:
=StartDate()
and
=EndDate()

 

[Mobiusrune]

Mihail all I can say at this point is Mulţumesc mult.

 

[Mihail]

If you wish to learn Romanian, I'm here. I have a huge need to learn English, so...
Glad to help you.
Good luck !