looking up next higher value in a table

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Hello,
I have a query that is pulling the sum of a field in a table based on
criteria. Then there is an expression field in the query that is
multiplying the sum by another number. What I want is a query that
will take the expression field and bounce it against a field in a
table. If it does not find an exact match, it returns the next higher
value in that field. If anyone could help me on this, I would greatly
appreciate it.
Jay
 
Hello,
I have a query that is pulling the sum of a field in a table based on
criteria. Then there is an expression field in the query that is
multiplying the sum by another number. What I want is a query that
will take the expression field and bounce it against a field in a
table. If it does not find an exact match, it returns the next higher
value in that field. If anyone could help me on this, I would greatly
appreciate it.
Jay
Click to expand...

Something like

=DMin("[fieldname]", "[tablename]", "[fieldname] >= " & [Calculated])


John W. Vinson[MVP]
 
Hey John,
I think that did the trick. Thank you very much. Databases are
great, but not when you have to whip them up in a short time. I
appreciate the help.
Jay
 
Back
Top