excel vba courses london - Databases and forms

Hi Martin,

You create them in Queries.

In a new field, you can do simple math, and also use functions. some of the functions are slightly different, and you may need to look into the help section to verify the syntax.


some examples:

[total]*0.175 (where [total] is a numeric field)

or

GrandTotal: [total]+[vat]

Or

Total: [unit_price]*[quantity]


Regards

Richard