Recent content by corbimae

I have a list of 20 hospital patients that I am trying to use to try and establish a list of supplies or services billed on Day of Surgery, Post Op Day 1, Post Op Day 2, Post Op day Three and Post Op Day 4. My problem is when I ran Crosstab Summaries on their accounts the column headings were...

The report is being created by Access using the original query. In the Query pane the Expression reads as follows: Expr4:[Daily Census Report].[Obstetrics This Midnight]+[Obstetrics OPO Midnight]+[OB SD] (syntax may be wrong but you get the gist). To get the report I highlighted the query title...

Thanks Paul, I'm still battling this thing. I know its some little something that I've missed...I finally understood the necessity of renaming the control and how not doing so can cause the Enter Parameter prompt. I renamed my controls by adding txt to the beginning as I read something about...

I Think its attached.

I don't have the db here so I will try to do it tomorrow when I finish with patients.

actually I did go into conditional formating. I can get the entire column to highlight if I key in something like ([Obstetrics Same Day Stay] >0) Out of 31 days in October our OB department only had 1 Same day stay and that was 10/3. What I'd like to happen to only have that day highlighted. I...

I'm trying to get a cell to highlight in a Report. On the Name and Source I see Expr1, Expr2 and so on. The numbers are being pulled from a Query whose data is obtained with a calculated control. [Obstetrics This Midnight] + [Obstetrics OPO Midnight] + [OB Same Day Stay]. On the report, I want...

Hi everyone, I'm a Physical Therapist/Manager in a small hospital in North Georgia. When I'm not seeing patients I like to work on databases. I want to thank everyone whose entries I have benefited from since I starting using this website. No doubt I'll be asking more questions than I answer...