two tables to one report

[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 Boyce]

Mandy

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

 

[Guest]

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 #.

 

[John Spencer]

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' ")

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 #.

Mandy

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

--
Regards

Jeff Boyce
<Office/Access MVP>