Search results

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

I didn't get the DAO error after selecting the DAO Library. But, I am still getting the error on my report. I have the expression written as follows: =DMedian("Expr1","qryDataAnalysisCenter") Does this look right? The article states that the last part is optional.

Do I only need to select the MS DAO Object Library? Is that what I am looking for?

Okay...(Nurse here and not IT professional)...Not to be dense, but the article states that to use this code I need to "Use the References command in the Tools menu to add the necessary reference". I did import the module just fine. Where is the References Command and is it supposed to be in...

I have a report that calculates a average value from a field. Is there a way to figure out the median value? I did not see a function for this.

That was what I was looking for. My problem was that I was using the Excel formula AVERAGE() instead of Avg([]). Much appreciation for the help.