Search results

I was messing around with different ways of doing the syntax and I found one that works! ![Tablename.Fieldname] Made my life a lot easier. :) Thanks for your help, though.

Yes, that's where the problem lies. My tables (Customers, SalesManagers, Children) all have fields called RetailWeek1 (2,3,4,etc). So, saying: !ResultRetailWeek1 = !AvgRetailWeek1 * !RetailWeek1 Doesn't work because RetailWeek1 exists in three tables. So, how can I reference exactly...

Hello all. I am getting an "Item Not Found in this Collection" error with the following code: s = "SELECT Customers.*, SalesManagers.*, Children.*" & _ "FROM (Districts INNER JOIN (Routes INNER JOIN (Children INNER JOIN Customers ON Children.ChildID = Customers.ChildID) ON...