DLOOKUP FOR CALCULATED VALUES

  • Thread starter DOMIRICAN via AccessMonster.com
  • Start date
D

DOMIRICAN via AccessMonster.com

Need help with the following code:
ID = numerical
pdate = is the date field in my query.

=dlookup("[Earned Hr]"/("[tpaid]"-("[project]"+"[Station]"+"[Break]"),
"productionqueryrpt","[dd]=#" & [pdate]& "# And [id]=" & [id]))

Please help!!!!
 
B

Bob Quintal

Need help with the following code:
ID = numerical
pdate = is the date field in my query.

=dlookup("[Earned
Hr]"/("[tpaid]"-("[project]"+"[Station]"+"[Break]"),
"productionqueryrpt","[dd]=#" & [pdate]& "# And [id]=" & [id]))

Please help!!!!
Click to expand...

too many quotes, misplaced )
=dlookup("[Earned Hr]/([tpaid]-([project]+[Station]+[Break]))",
"productionqueryrpt","[dd]=#" & [pdate]& "# And [id]=" & [id])
 
Top