I am writing VBA code in a report code module. I need to make
calculations that display on the report based on information on a
query. What is the syntax for that? The logic is below.
if query.field = 1 then
do calculations
else if query.field = .1 then
do calculations
else
do calculations
This is in MS Access using VBA code. Thanks all.