Search results

I have two formulas that both work by themselves: 1. IIf(Nz([Approved])=0,0) 2. IIf(Nz([Allocated])+(Nz([Carryover]))=0,0) But what I really need is to combine these formulas so that if either is true a zero is returned. Here is one combined version I tried...

Thanks for all the help; everything is working perfectly! Wm

Access 2003 Report Formula Here is a formula that returns what I need as long as the fields being added have at least one field with a value greater than or equal to zero: =Sum([Paid])/Sum([Approved]) This returns the sum of the Paid column divided by the sum of the Approved column...

Bob, There were indeed some empty rows that were showing up and I deleted those. There are fields in the problematic column that need to have nothing in them (not sure if that means empty string). I selected them, hit the delete button to clear unseen content, and then formatted as number...

No 10-digit numbers, but thanks for that tip as it might be an issue later.

I have an Excel file that is linked to an Access table. In the Excel file there is a column formatted as a custom number. But in the corresponding column in the linked Access table the data doesn’t show up because the column in Access is formatted as “Text.” What is showing in the column in the...

Gentelman, Changing the border to 1pt worked perfectly. Thanks SO much; I had just about given up hope. Please have a wonderful holiday season.

Well, I tried nudging the heigth of the footer and moving the lines away from the edges as well as the controls, and I still get the same result. Also, if the lines were being encroached on by the controls, that should cause the same error at the bottom of every grouping. The missing lines...

I have a report that has a printing anomaly. The report groups on matching field numbers (left hand column) like this: 10000 10 11 10000 20 21 _____________________________ Total 30 32________________ 20000 4 6 20000 5 9 _____________________________ Total 9 15________________ 30000 8 7...

thanks, this worked well.

I am using a formula in a report text box that sums two other fields: A + B = C However, if either field A or B is empty (no value at all), field C is empty as well. I'd like to be able to leave A or B empty and get a result in C. Examples: A (with a numerical value) + B (empty field) = A...

I have a qry named qryAllocList-FINAL. I right clicked on it, copied, and pasted as qryAllocList-FINAL+SUPPLEMENTAL. Immediately when I open up the copied version I get an "Enter Parameter Value" pop up with the reference "qryAllocList-FINAL.DistrictCode" above the window in which to enter a...

How I love a perfect solution that is simple! Thank you SO much. Wm

I would like the first page of a report to begin with a page number greater than one, and then continue sequentially. Is this possible in an Access report and if so, how? Thanks, William