I really need some help here!
On a report I want to show the planned time for an activity.
But I want it to appear behind the customer for which the activity was done and the employee who did the activity.
I came up with the following DLookup expression but it just doesn't work and I've tried numerous ways but it just doesn't show (and I know that there are numerous records to be shown, so there is no Null value).
=DLookUp("[rap_planned_time].[calculated_time]";"[rap_planned_time]";"[rap_planned_time].[customer_id]=[customer_id] AND [rap_planned_time].[employee_id]=[employee_id] AND [rap_planned_time].[activity_id]=[activity_id]"
actually I want to include the BETWEEN criteria too but I've never done that in a DLookUp expression (actually I quite suck at Dlookup) so tell me if the "experiment" below is correct (or just a miserable failure...).
it should actually do the following (plus the above mentioned stuff)
[rap_planned_time].[activity_date] BETWEEN [Date1] AND [Date2]
=DLookUp("[rap_planned_time].[calculated_time]";"[rap_planned_time]";"[rap_planned_time].[activity_date] BETWEEN [Date1] AND [Date2] AND [rap_planned_time].[customer_id]=[customer_id] AND [rap_planned_time].[employee_id]=[employee_id] AND [rap_planned_time].[activity_id]=[activity_id]"
Background info:
The report is based on a query [rap_work] which gets the activities that have been done.
I cannot add the fields I need from [rap_planned_time] to [rap_work] because of numerous reasons but I really need that information so thence the DLookup expression.
I really need some help here so if anyone could tell me WHAT I'm doing wrong and what it should be I would be very gratefull.
Florens
On a report I want to show the planned time for an activity.
But I want it to appear behind the customer for which the activity was done and the employee who did the activity.
I came up with the following DLookup expression but it just doesn't work and I've tried numerous ways but it just doesn't show (and I know that there are numerous records to be shown, so there is no Null value).
=DLookUp("[rap_planned_time].[calculated_time]";"[rap_planned_time]";"[rap_planned_time].[customer_id]=[customer_id] AND [rap_planned_time].[employee_id]=[employee_id] AND [rap_planned_time].[activity_id]=[activity_id]"
actually I want to include the BETWEEN criteria too but I've never done that in a DLookUp expression (actually I quite suck at Dlookup) so tell me if the "experiment" below is correct (or just a miserable failure...).
it should actually do the following (plus the above mentioned stuff)
[rap_planned_time].[activity_date] BETWEEN [Date1] AND [Date2]
=DLookUp("[rap_planned_time].[calculated_time]";"[rap_planned_time]";"[rap_planned_time].[activity_date] BETWEEN [Date1] AND [Date2] AND [rap_planned_time].[customer_id]=[customer_id] AND [rap_planned_time].[employee_id]=[employee_id] AND [rap_planned_time].[activity_id]=[activity_id]"
Background info:
The report is based on a query [rap_work] which gets the activities that have been done.
I cannot add the fields I need from [rap_planned_time] to [rap_work] because of numerous reasons but I really need that information so thence the DLookup expression.
I really need some help here so if anyone could tell me WHAT I'm doing wrong and what it should be I would be very gratefull.
Florens
