Recent content by DrDoIT

is there a way to make it just sum the 30+40+180 and ignore the rest of the figures? this is because the Cumulative Patients 30 already contains the New Patients 10 and 15; cumulative 40 already contains the New Patients 8 and 20 etc

Thanks JHB, Mihail. as Mihail noted earlier - it's most likely the issue of the design. i will redefine the fields. DrDoIT

Hello Forum, i have managed to attach the table. The three health facilities have the following sub totals in the Facility Footer. New York Hosp - 30 London Hosp - 40 Nairobi Hosp - 180 I would like the correct totals of 250 in the report footer as shown in the table but instead the...

Hello Forum,the table format in the post below is totally messed up during posting.in summary the cumulative Patients at end of Feb is a sum of the new patients in February + patients end of Jan etcData is as below : Facility A : New Patients Jan (5) Feb (30). Cumulative Patients Jan (5), Feb...

Hello Forum, Kindly assit me solve the following problem. i have read the posts on running totals but somehow i cant solve it right. i have a table with health facilities (A,B,C,D) . each health facility has data from several months (Jan, Feb, Mar etc). the table has 2 fields (New Patients) and...

Hello Forum, Kindly assit me solve the following problem. i have read the posts on running totals but somehow i cant solve it right. i have a table with health facilities (A,B,C,D) . each health facility has data from several months (Jan, Feb, Mar etc). the table has 2 fields (New Patients) and...

thanks, this worked great. DrDoIT

Hello Forum, I would like to change the text color in a field depending on the value in the field called Results. The code I have entered is as below. Private Sub Report_Load() If [Results] = "POSITIVE" Then [Results].ForeColor = RGB(255, 0, 0) Else [Results].ForeColor = RGB(0, 0, 255) End If...

Thanks Brian, Thanks Bob This works perfect! [Forms]![Parameter Form]![Combo27] Is Null Or [YourFieldName]=[Forms]![Parameter Form]![Combo27] Thank you DrDoIT

Hello Forum, kindly assist me solve the following problem. I have a Parameter form which provides various parameters to my queries. The Parameter Form has a Combo box with a list of 50 health facilities which the user can select according to their needs. There are instances when a user needs...

thanks, i think i will try the command buttons. DrDoIT

Hello Paul, Hello Forum, Sadly i have little progress to report on my wish for one (or just a handful) of parameter forms. some of the reports i have are named as follows : 1. HTC SOC - Quality Assurance 2. 711TB Standard Report 3. 731PMTCT Standard Report etc. how do i use one Parameter...

thanks Paul and Nigel, your suggestions were very helpful, the form works much better. one problem though, a 'Enter Parameter Value' Dialog box appears first with the following display text : Lookup_FacilityName.FacilityName when i enter (or dont enter) any value and click OK, the...

Hello Forum, I have been trying for several days to develope a form to supply parameters to a query and a report in my database. the sample code in the form's On open Event procedure as as below : Option Compare Database Private Sub Ok_Click() Me.Visible = False DoCmd.OpenQuery "711ARTData...

Grouping the months using IN has worked very well for me. Next moving on to try the VBA ones posted below. Thanks all for stepping in. DrDoIT