Recent content by copleyr

  1. C

    Max of Multiple columns, with constraints

    Please see attached. Final return is in last column of "qry_Return Query Output"
  2. C

    Max of Multiple columns, with constraints

    i ended up figuring it out....thank you sir!
  3. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints So something like this? : Option Compare Database Option Explicit Function Maximum1(ParamArray FieldArray() As Variant) ' Declare the two local variables. Dim I As Integer Dim currentVal As Variant '...
  4. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints I'm not sure if I want to take this out: Else 'it's odd, an actual value If IsNull(FieldArray(I)) Then 'actual is null, use last scheduled max Maximum1 = currentVal Exit Function End Ifbecause I still want it to...
  5. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints That was my mistake. If one level is blank, then it doesn't necessarily mean it's an error; it just means that there was not a scheduled or actual date for that level. Therefore the logic still applies: If array of actual dates isnull and...
  6. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints bumping because im desperate to make this work
  7. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints Thanks again for your help! This code worked out perfectly for what I was trying to accomplish at the time: Option Compare Database Option Explicit Function Maximum1(ParamArray FieldArray() As Variant) ' Declare the two local variables. Dim...
  8. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints I have checked it and so far it looks EXCELLENT. Our analysts have alot of cleanup to do. Many thanks for your time. You are my savior!
  9. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints This means that there is in error in the data and it needs to be fixed by one of our analysts. In this case, can it return "check data"?
  10. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints Here you go. I tried to make it as simple as possible. The last column in the query is what I am trying to return.
  11. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints I was unsure how to apply VBA, so I tried this approach: Scheduled Return: IIf((IsNull([kdrivecrm701]![Scheduled RDG Date]) And IsNull([kdrivecrm701]![Approved RDG Date]) And IsNull([kdrivecrm701]![Pursuit Decision Scheduled]) And...
  12. C

    Max of Multiple columns, with constraints

    Re: Max of Multiple columns, with contstraints Thank you sir. How would I change the code up to be able to do that? My apologies as I'm not familiar with this type of logic.
  13. C

    Max of Multiple columns, with constraints

    Hello all, I am trying to put together a function in a query that will identify and return the correct date in a record. For example, in the below chart: For my function to work, I need it to return the next upcoming "Scheduled" date, without skipping to another level if...
  14. C

    Max of multiple columns

    i have to have 10 posts to post an image for my next question...so i need to post 1 more time
  15. C

    Max of multiple columns

    i have to have 10 posts to post an image for my next question...so i need to post 2 more times
See more
Back
Top Bottom