D
DEI
I have SQL statement written into two list boxes on a form
to query sums from two different queries. I would like to
add a control to the form that somes the two resultant
values that appear on the form. =[Control1]+[Control2] in
a text box doesn't work, I assuming because the two
controls are technically list boxes.
I have tried all sorts of ways around this. I don't want
to write an SQl statement with a join and have to define a
relationship, etc. Is there any way to convert these
numbers on the form to a usable format for calculations?
Or maybe write a row source statement that combines the
two current values? I would also like to perform some
calculations with other values on the form pulled from
different places.
These value willnot be bound to tables, they will be for
display purposes only.
Thanks
to query sums from two different queries. I would like to
add a control to the form that somes the two resultant
values that appear on the form. =[Control1]+[Control2] in
a text box doesn't work, I assuming because the two
controls are technically list boxes.
I have tried all sorts of ways around this. I don't want
to write an SQl statement with a join and have to define a
relationship, etc. Is there any way to convert these
numbers on the form to a usable format for calculations?
Or maybe write a row source statement that combines the
two current values? I would also like to perform some
calculations with other values on the form pulled from
different places.
These value willnot be bound to tables, they will be for
display purposes only.
Thanks