benjamin.weizmann
Registered User.
- Local time
- Yesterday, 22:35
- Joined
- Aug 30, 2016
- Messages
- 78
Hi friends,
I'm begging to solve it:
how to write the part of the dlookup correctly
thanks you!!
Ben
Me.Graph38.RowSource = "SELECT graph.[numoutt], Sum(graph.[quantity_pro]) AS SumOfquantity_pro, DLookup('yellow_range', 'machine', 'IDnum=' & [graph]![machinenum] & '') AS g " _
& " FROM graph" _
& " GROUP BY graph.[numoutt], graph.ID,graph.[machinenum], g" _
& " HAVING (((graph.[machinenum])=" & Me.List2.Value & "));"
I'm begging to solve it:
how to write the part of the dlookup correctly
thanks you!!
Ben
Me.Graph38.RowSource = "SELECT graph.[numoutt], Sum(graph.[quantity_pro]) AS SumOfquantity_pro, DLookup('yellow_range', 'machine', 'IDnum=' & [graph]![machinenum] & '') AS g " _
& " FROM graph" _
& " GROUP BY graph.[numoutt], graph.ID,graph.[machinenum], g" _
& " HAVING (((graph.[machinenum])=" & Me.List2.Value & "));"