Recent content by Mobiusrune

Thanks for the link to the article. My hope was to be able to have a find next button while having the drop down combo box for the original search. The find/replace that pops up with the Find Record button seems to be confusing for some users. All the users were comfortable with the combo...

I am having issues with assigning search criteria for the "Find Next Button". I used the wizard and it does not ask what criteria to use for Find Next. I am assuming there is a bit of VBA I need to add to the generic Find Next button. This is what comes up when I use the wizard to create the...

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

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

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.

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...

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

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

Yes I have an original copy (and a backup). For Text 132 I have tried it both ways and when I run the report the output is #Error. :banghead:

Nope. Does not fix it.

Okay...compacted and repaired...and zipped. This is what happens when you throw a nurse into IT...but I am having fun with this...

The issues is getting the Median values for the Expr# fields in the two reports. PtMRN field is blank r/t Protected Health Information.

No, because it is late and my brain isn't working...here it is...

It won't let me. Upload only allows for 2MB and this is 5.3.

Expr1 is the Field name. It is a calculated field in a qry based off of other fields from a table. Expr 1 is something like this: IIF([Time1]>[Time2],DateDiff("n",[Time1],[Time2])+1440,DateDiff("n",[Time1],[Time2])) Access automatically calls this field in the query Expr1. Expr1 is...