Search results for query: *

That's what I get for not previewing my post. This is what I should have pasted. WHERE Nz(Data.S_Race_1)=Nz(Data.Race_1) AND Nz(Data.S_Race_2)=Nz(Data.Race_2) AND Nz(Data.S_Race_3)=Nz(Data.Race_3) AND Nz(Data.S_Race_4) = Nz(Data.Race_4) and data.[EditUser ID] is not null; Written this way it...

WHERE Nz((Data.S_Race_1)=Nz(Data.Race_1)) AND Nz((Data.S_Race_2)=Nz(Data.Race_2)) AND Nz((Data.S_Race_3)=Nz(Data.Race_3)) AND Nz((Data.S_Race_4) = Nz(Data.Race_4)) and data.[EditUser ID] is not null;

Thank you. I took a look at the Nz function and put in my query, but I still came back with zero records.

Thank you for your quick response. I failed to mention the "null value" fields. The example I enclosed should have also included two columns of information where two of the fields IE:(S_Money and Money) had no value and there by are equal, but the way I had it written and the way I changed it to...

I have one table with multiple columns and I need to bring back via a query all records that have matching data AND a Review By > 0 IE: S_Money = Money and S_APR = APR, etc. S_Money Money S_APR APR S_Income Income Reviewed by 50 50 7.8 7.8 40000 40000...

I know, that's what it appears to have happened, but I doubled checked it after reading this. I even "mouse over" the entry in the group footer (city) and it reads SUM of @funded (number).

I have done exactly as you suggested yet now I have over 800 pages and the data is incorrect. IE: One city has eight(8) "Y"'s and (0) zero "N"'s. In the SUM of all funded loans I have (22) twenty two. All the city groups are the same as far as exaggerated amounts. It happens as soon as I add the...

Adding a column on an already existing report and pulling the data from sheet 2 in Excel. Sheet 1 is where the rest of the information comes from. Group 1 Name = "Reviewed" and "Not Reviewed" (Sheet 1) Group 2 Name = State (Sheet 1) Detail Section includes: City, Tax and No Tax. (Sheet 1)...

Thank you very much. I am all set. Great help!

Thank you. I am getting closer. Once I completed the boolean arguement I was successful for that one field. Now I need to put together a series of these formulas to look at all the fields on this report and evaluate accordingly. Here is what I have so far. Please comment where needed. There are...

Using this formula (isnull({FILE1.Reviewer}) or {FILE1.Reviewer} <> "") which is entered in the Group selection formula editor I am still getting all the reference numbers back. What I would expect to see is only those reference numbers that have FILE1.Reviewer field blank or "null". The...

My formula looks like this and I am getting a missing ) error message. if (isnull({FILE1.Reviewer} or ({FILE1.Reviewer} = "")

I am building a report that needs to look at a database and pull only the data that is incomplete. Incomplete is defined as being empty or "null". IE: I want to see all the reference numbers that have certain fields that are NOT filled out. There are twenty fields that should be filled out each...

Per group and the groups are defined as "F" and "NF

This is the formula for SAMPLE SIZE (If {FILE1_Review.Name}="RB" and {FILE1_Review.Type}="NF" then 25 else (If {FILE1_Review.Name}="RB" and {FILE1_HMDA_Review.Type}="F" then 25 else 10)) This is the formula for FILES RECEIVED: ToNumber({FILE1_Review.Type}= ["F","NF"] and...

In the formula editor I added the formula's for {@Files on Order}and{@Files Received}. They were also entered into the Running totals section and that is why I steered you in the wrong direction inadvertently. Than I created a fourth formula entitled Additional to order and used the enclosed...

The {@Sample size}is a formula field created to populate a distinct number based off of other field criteria. IE: (If {FILE1.Name}="RB" and {FILE1.Review.Type}="NF" then 25 else (If {FILE1.Name}="RB" and {FILE1.Review.Type}="F" then 25 else 10))

Yes I am using the running totals and I have done exactly as requested. Then I get the following message THE FOLLOWING TEXT DOES NOT APPEAR TO BE PART OF THE FORMULA. (@Sample Size) is column A and so on. running total for {@Sample Size}- running total for{@Files on Order}- running total...

In place of the A , C and D I pulled in the report fields that they represent. Once I did that and checked the formula I got a "Field Name not known" message. The formula ia as follows" {#rt{@Sample Size}}-{#rt{@Files on Order}}-{#rt{@Files Received}} Your help is greatly appreciated.

I have column A - Required Amount of Inventory Column C - Amount of Inventory ordered Column D - Amount of Inventory Received I am interested in Column E - Amount needed to be ordered. The first three columns are alrady on the report and are correct using Running totals. I need to take...