DMax from multiple fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jlapierre8
    New Member
    • May 2007
    • 2

    DMax from multiple fields

    Hello! I'm trying to return the maximum value from four different fields in each record. I tried DMax, but that only returns the Max record in one field. Any suggestions?
  • JConsulting
    Recognized Expert Contributor
    • Apr 2007
    • 603

    #2
    Originally posted by jlapierre8
    Hello! I'm trying to return the maximum value from four different fields in each record. I tried DMax, but that only returns the Max record in one field. Any suggestions?
    How are you attempting this...a query?

    Comment

    • jlapierre8
      New Member
      • May 2007
      • 2

      #3
      Originally posted by JConsulting
      How are you attempting this...a query?
      I'm trying it in expression builder.

      Comment

      • JConsulting
        Recognized Expert Contributor
        • Apr 2007
        • 603

        #4
        Originally posted by jlapierre8
        I'm trying it in expression builder.
        can you paste in what you have?

        Comment

        Working...