I am having difficulties with a report used to view fertilizer elements. The report is based on a qry in which I have created several fields where the total amount of fertilizer is divided & multiplied to arrive at a %. This works ok. These Text Box fields (percentages) are placed into the report, so far so good. I then sum the text boxes, for example I have three text boxes for Sulphur content of three different fertilizers. Textbox:fertilizer1S, Textbox:fertilizer2S, Textbox:fertilizer3S
My report will sum each of the above just fine. My problem arises when I want to sum the three text boxes shown above. I have tried adding the three in the report footer after summing in the detail section or report footer ( many ways) & usually end up with nothing showing at all. I must be missing something small, hopefully.
My report will sum each of the above just fine. My problem arises when I want to sum the three text boxes shown above. I have tried adding the three in the report footer after summing in the detail section or report footer ( many ways) & usually end up with nothing showing at all. I must be missing something small, hopefully.