Search results

This what I am using, but for some reason it isn't working. It says something about an aggregate function. # of Days: IIf([Reactive Date] Is Null,(DateDiff("d",[Date Opened],[Date Declined/Closed])),(DateDiff("d",[Inactive Date],[Reactive Date])))

Below are the two calculations i did, then I created the IIF statement below. It works fine, but the query is constantly asking for Total Days and Inactive Days Parameter. Total Days: DateDiff("d",[Date Opened],[Closed Date]) Inactive Days: DateDiff("d",(IIf([Inactive Date] Is...

That is the issue, there may not always be a Inactive date. Some deals go away completely and if they have been inactive long enough it gets closed out. But some deals will not have any inactive dates. So my problem is that two dates fields (Inactive and reactive) could be null often.

I need to calculate a way to count the number of days a deal takes to close. The problem being we only want to count days that it is actually being worked on. So I have four date fields: Open Date, Inactive Date, Reactive Date, and Close Date. I wanted to create an expression that counted the...

The actual issue isn't with the names. It is with the expression, "Total Days", "Inactive Days", & "# of Days". the query is prompting a parameter value for Total days and inactive days.

I have a query with 4 date fields, and with two expressions that use datediff with those fields. Then I take an IIF statement and create an expression of datediff 1 - datediff 2. the problem is some of my date fields will be null. Here is my SQL: SELECT [Customer List].[Company Name], [Loan...

From a preliminary bases I think it is working correctly. Thank You So Much... Just a question so i can become smarter. What does the Nz and the 9999 do in the expression? But thank you again, if it still isn't working quite right i am sure i will be back.

Now is is saying that I have invalid syntax. That I have an operand without an operator

Attached is the screen shot with the expression builder open and also the screen shot after i try to run the query.

It was missing a bracket was why it wasn't working originally. Now it is asking for MyDateField Parameter.

Actually it won't let me put it into the column. the expression keeps disappearing. How should i enter it SQL? It says maturity date doesn't have an operator

Not working, for some reason it gives me the same results as my query.

This is the SQL for the current Query where Rate Change Date takes priority, and reverts to Maturity date if Rate Change is Null. Maybe this will help with a solution. SELECT [Loan Information].[Loan ID], [Loan Information].[Call Report Type], ([Loan Information]![Master Loan Balance]+[Loan...

No... it doesn't matter if Rate Change Date is null... I just need to pull oldest date whatever date column it should come from. The Rate Change Date may have data or may not.

Bob, I am wondering if you may have the answer to this query. You just seem to understand this all much better than. My query is working grreat from the last issue. Now I come to find that I can't give Rate Change priority over Maturity I need the query to pull the data only into the...

Nevermind... I got the query to do what i wanted... at least for now. The best fix would be for the query to pull the oldest date field which ever field it came from Maturity or rate change. But let's hope this works.

Would i do that with the union query or should i create a new query with all the date ranges and criteria with the above IIF statement?

So there are two date fields: Maturity Date and Rate Change Date. There are six date ranges needed, along with the six ranges, I have specific criteria for loan status, Call Report type and on top of that i have a calculated field "Call Report Balance." Basically i need the report to generate...

Thanks it just wasn't uploading for some reason. Do you think there is a way to write an IIF state for the above attached DB to give priority to one date field, and if that date field is null it would allocate the data to the second date field?

Jdraw, I finally figured out why it wasn't let me attach it. It was because I need to downgrade the Access version, i am currently working on 2007 and it would only take 2003. Hopefully this will help.