Search results

OK, I have another field that I am having a similar issue with and I can't seem to get the same solution to work. Here's the formula: Days Recvd to 1st Decision: IIf(DateDiff("d",[CDF90 DATE- CREDIT RECEIVED BY UW],[First UW Result Date])<0,Null,DateDiff("d",[CDF90 DATE- CREDIT RECEIVED BY...

That worked, thanks a lot!

Hmm that didn't work either. Returned 0 rows. Thanks anyway.

Thanks for the suggestion. The problem with that is that there are legitimate results of 0 days that I need to take into consideration once I build a report from this data in Excel, so that would skew the results..

I have a field that calculates the difference between two dates (formula below). It is outputting in numeric format (I looked at the table in design view). Whenever I add a criteria of <365 (to help eliminate bad data) the whole query returns a table with no information. Without any criteria...

I ended up just using the "Day" function. Here's the code that finally worked: UW Receipt Range: IIf(Day([CDF90 DATE- CREDIT RECEIVED BY UW])<11,"1-10",IIf(Day([CDF90 DATE- CREDIT RECEIVED BY UW])<21,"11-20",IIf(Day([CDF90 DATE- CREDIT RECEIVED BY UW])<32,"21-EOM","NA")))

I get how the Iif's work, it is simple. I thought I was screwing up the syntax a bit though. I just tried this code and it says "The expression you entered has a function containing the wrong number of arguments."

No, I don't know how. Sorry, I'm a big newbie at this stuff. I found a code snippet that was doing something similar and tried to adapt it to my use. I have tried a few different variations of what I posted and am still getting errors. I don't really know the proper syntax.

That could be, I probably need to put 'dd' I'm thinking, but I think there's another problem before that because Access is saying "The expression you entered has a function containing the wrong number of arguments".

I am trying to create a calculated field that outputs what date range of the month a file was received by a department. I want to create the following groups: day of month 1-10 in one group, days 11-20, and 21-EOM. I tried to create a formula to do this and I think I messed up something...

I found another function that somebody had created online that worked. Here's the code FYI. Function fMin2(ParamArray varValues() As Variant) As Variant Dim I As Integer, vMin As Variant vMin = varValues(0) For I = 1 To UBound(varValues()) If IsNull(vMin) Then...

Well, that didn't work either. I may end up having to make a new DB to show you what I'm working with, but I don't think I can include the linked tables I'm querying from, so the query is just code. One thing-- when I run the query it asks me to enter a Parameter Value for First UW Result Date...

No, I can't because it's massive and has confidential customer info. There are like 700,000 records it has to go through, I think. I wish I could, sorry. I doubt this will help but here's the actual calculated field formula-- First UW Result Date...

Hmm, that didn't work either. Thanks for the input though, I appreciate it. This was my code-- Option Compare Database Function Minimum(ParamArray FieldArray() As Variant) ' Declare the two local variables. Dim I As Integer Dim currentVal As Variant ' Set the variable...

Hmm, that didn't work. It still generates a null field if any of the fields it looks at are null. I want it to pick the lowest of the fields that has a value in it. Here's my code now-- Option Compare Database Function Minimum(ParamArray FieldArray() As Variant) ' Declare the two local...

OK, actually I didn't get that to work. I have Maximum working because I found help elsewhere that said to put Nz around FieldArray(I). I've tried putting the If statment you mentioned in a couple of different places but I can't get it to work. Here's my current code-- Function...

Thank you!

I am trying to find the earliest date out of 6 different date fields (some of which may be null). I found this article on the Microsoft Site (support.microsoft.com/kb/182760) that helped me create a module so I have a function called Minimum and Maximum that seems very easy to use, and in fact...

Hi, I'm a newbie here, and pretty much a big newbie with Access too. I live in Minneapolis, Minnesota, US. I work at a bank that isn't very good at keeping up with technology. I am relatively new in my position and could definitely use some help here and there. I found this site from...