DLookUp Error is frustrating!!!

A

Alex B

I have tried many different syntax's (both with and without criteria) to get
the DLookUp function to work, but I always get an #Error.

I am trying to create a report that's record source is based upon one query,
but then perform some calculations in each of the group footers based upon
information from another query. The basic structure of the detail section
report is:

Jan Feb Mar .......... Dec
Employee1
Work Hrs ### ### ### ###
Vac Hrs ### ### ### ###
Sick Hrs ### ### ### ###

Employee2

All of this part of the report is fine, but in the group footer, I need to
return a value based upon a different query that pulls the total available
work hrs and holiday hrs. I have tried building different (Totals) queries
for the overall (available Work Hrs and Holiday Hrs, and I have even tried
isolating just the Work Hrs in a query that only returns the one row for Work
Hrs by month. Here are the DLookUp functions that I tried:

=DLookUp("[SumOfJanuary]","[Company Monthly Hours Totals]","[Day Type] =
'Workday'") .... This function tries to isolate only the Work Hrs from one
query based upon the criteria...

=DLookUp("[JanuaryWrkHrs]","[CompanyWorkHours]") ...This function only
needs to pull the January total because there is only one record in the query.

Please help, this is driving me nuts.
 

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

Report Group Footer DLookUp 0
DLookup in Continuous form 0
Why is the average in my report footer giving the wrong calculation? 3
Using "Avg" function on calculated field 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to add a total from three other sums in a report 5
Report Sums of Sums 1
Dlookup repeat 5

Top