Search results

It works! Here is the correct syntax for adding all TotalValue for a particular client after a certain date. couldn't find an example of this anywhere. took far too long but its working now. thanks to all who helped DueValue = DSum("TotalValue", "tblOrders", "[ClientID] ='" & strClientID & "'...

Ok noted about the msgbox problem. i see that you cannot use table data on a msgbox ambiguously. Aside from that issue The main problem is below: Im Not getting an error anymore but TotalValue is summed up for all Orders. I want Totalvalue to be added only if the due date has passed. So the...

Trust me guys thats not it. I keep getting "external name not defined" error no matter how i try to use [tblOrders]!DeliveryDate or anything in table orders for that matter here is whole code code: Dim DueValue As Variant DueValue = 0 'MsgBox "Today is '" &...

The problem seems to revolve around [tblOrders]. I cant seem to use any table data when outside of a method. do i have to declare a table before i use it and how do i do it. what do you mean by 'proper' declaration? Even this wont work!!! MsgBox "Today is '" &...

First two dont work. something is still wrong with DateAdd(m,3,[tblOrders]!DeliveryDate) I know this because when i run This DueDate = DateAdd(m, 3, [tblOrders]!DeliveryDate.ItemData(1)) MsgBox DueDate I get "Compile Error: external name not defined" highlighting [tblOrders] can anybody...

Thanks for the quick response. No joy though. I just tried this and it didn't work DueValue = DSum("TotalValue", "tblOrders", "[ClientID] ='" & strClientID & "' AND DateAdd(m,3,[tblOrders]!DeliveryDate)>#" & Date & "#") Also I check the date format by Dim DeliveryDat As Date DeliveryDat...

Hi all Im new and am finally looking for some experienced help, Ive been trying to fix this for a few days. My database has the typical structure Clients>Orders>OrderDetails>Products.....In tblOrders there is a DeliveryDate and TotalValue field. I want to create a DueAmount module that Sums all...