Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this in a query, two seperate columns:

Expr2 Total Sales
1 $1,290,262.28
2 $1,156,311.50
3 $1,282,886.09
4 $1,009,097.57

How can I perform a vlookup "type" of formula to lookup "3", and return
$128,2886.09. I need to use this formula in a form. The form IS linked to
the query. I belive I need to use a dlookup but I can not get it to work.
Thank You.
 
DLookup("[Total Sales]", "MyQueryName", "Expr2 = " & 3)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"Send Object Command - Two attachments"
 
Back
Top