Search results

SELECT [tblOrders].CustomerID, Count([tblOrders].CustomerID) AS OrderCount FROM [tblOrders] LEFT JOIN tblCustomer ON [tblOrders].CustomerID = tblCustomer.CustomerID GROUP BY [tblOrders].CustomerID; pr2-eugin, where do I put this in? It's because I've only been taught to do queries via the Query...

Clarkie, I'm going to be honest here and say that most of it made little sense to me (I am not trying to offend you; I apologise for being a dummy). I'll try to better explain what I'm after. So this is what my database looks like (nothing complicated): tblCustomer CustomerID [Primary Key...

Hi I'm fairly new to Access and would like a bit of assistance. I have tables called tblCustomers, tblStock and tblOrders. One of the fields need to be an OrderCount field, which is supposed to increase by 1 every time a customer orders. For example, whenever Bob orders something for the first...