Hello,
one question. Is it possible to run DLookup for each record in reports.
I have only a table with names of a companies (company.value) and now I want to SUM all traffic with them in another table and store them in payed.value textbox for each company. The expression for one company should go like this:
traffic.Value = DSum("[payed]", "payments", "[payed] = TRUE AND [company] = '" & company.Value & "'"
The output would be
--------------------------
Coca-cola 500.000 $
Microsoft 200.000 $
...
--------------------------
Get the idea? Thanks for the answers!
one question. Is it possible to run DLookup for each record in reports.
I have only a table with names of a companies (company.value) and now I want to SUM all traffic with them in another table and store them in payed.value textbox for each company. The expression for one company should go like this:
traffic.Value = DSum("[payed]", "payments", "[payed] = TRUE AND [company] = '" & company.Value & "'"
The output would be
--------------------------
Coca-cola 500.000 $
Microsoft 200.000 $
...
--------------------------
Get the idea? Thanks for the answers!
