Hi All,
I've become fairly familiar with VBA while working on my current project but have zero understanding of SQL.
As a result all the queries I've written so far have been done in design view.
I now need to write an If statement in a query but don't know where to begin.
My problem is:
I need to calculate VAT on purchases but only if the VAT field is ticked.
How do I write this in design view?
And if there is not an easy way to do it in design view, how do I do it in SQL but please use the simplest SQL you can as I'm a complete novice.
I've become fairly familiar with VBA while working on my current project but have zero understanding of SQL.
As a result all the queries I've written so far have been done in design view.
I now need to write an If statement in a query but don't know where to begin.
My problem is:
I need to calculate VAT on purchases but only if the VAT field is ticked.
How do I write this in design view?
And if there is not an easy way to do it in design view, how do I do it in SQL but please use the simplest SQL you can as I'm a complete novice.
