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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relative Date & Crosstab problem 2
DATABASE REPORT/CROSSTAB QUERY HELP 2
DLookup Expression trouble 5
dlookup problem 5
dlookup challanges 1
Access Modules 1
Error message in Dlookup 2
Using A Dlookup Function On A Form When A Combo Box is Updated 2

Top