hello-am attaching database- open qry1 and you will see fld1 and fld2-
fld2 is same number as fld1 - only 1 is added to last number
example [fld1] 10.236.4.231 and [fld2] is 10.236.4.232
I manually added 1 to the numbers in fld2 -
Is there a way to create a field in the query that calculates this? and so the query is creating fld2?