Hi Everyone
Firstly I'm new to SQL but we all have to start somewhere, here's my question...
I have a textbox in a report which in the 'controsource' i have placed =Sum([Quantity])
which sums the whole 'Quantity' column great but what if I only want specific customers to sum using the WHERE criteria??
=sum([Quantity]) WHERE ([Customer]) = "Woolworths"
Whats the correct way of doing something like the above??