two tables to one report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mandy J.S. - 06 Dec 2005 12:36 GMT

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?

Reply to this Message

Jeff Boyce - 06 Dec 2005 13:49 GMT

Mandy

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

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> 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
[quoted text clipped - 4 lines]
> 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?

Reply to this Message

Mandy J.S. - 06 Dec 2005 14:31 GMT

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
>
[quoted text clipped - 11 lines]
> > 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?

Reply to this Message

John Spencer - 06 Dec 2005 16:41 GMT

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,
>
[quoted text clipped - 26 lines]
>> > the
>> > value of the "Cabs Produced" from that table for that particular date?

Reply to this Message