two tables to one report

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

Guest

I have a table "Flint Operations" which contains the "Task" field. When the
"Task" is equal to "Cabs Produced" I want the value. I have another table
"Quality" which feeds the report "Quality Daily Report". In the Date footer
I already have it counting the number of "Defects". I want to take the
number of "Defects" that were counted and divide it by the value of "Cabs
Produced" and have it appear in the Date footer with the text box next to it
saying "Number of Defects per Cab:". How do I get the report to grab the
value of the "Cabs Produced" from that table for that particular date?
 
Jeff,

I am trying to use that function, but coming up with an error. I have tried
writing it as follows:

=DLookup ([Actual], tblFlintOperations, [Task] = "Cabs Produced")

I just get an error #.
 
Syntax error.
The arguments to DLookup should all be strings. So your would need
something like:

=DLookup ("Actual"," tblFlintOperations", "Task = ""Cabs Produced""")
or
=DLookup ("Actual"," tblFlintOperations", "Task = 'Cabs Produced' ")


Mandy J.S. said:
Jeff,

I am trying to use that function, but coming up with an error. I have
tried
writing it as follows:

=DLookup ([Actual], tblFlintOperations, [Task] = "Cabs Produced")

I just get an error #.

Jeff Boyce said:
Mandy

Take a look at the DLookup() function in Access HELP.

--
Regards

Jeff Boyce
<Office/Access MVP>
Click to expand...
Click to expand...
 
Back
Top