Recent content by hld24

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...