nicks60610
MIS
(Access 97)
I am trying to multiply 2 fields in my Query and then somehow show the total in a separate field so I can use this number later, but I am completely unable to make this happen. I have 5 fields, 2 of which are numbers, so in the 6th field I typed in
"Total:[Std Qty]*[Qty]"
Now how can I display the "Total" so I know what the calculation is?
Thanks in advance,
I am trying to multiply 2 fields in my Query and then somehow show the total in a separate field so I can use this number later, but I am completely unable to make this happen. I have 5 fields, 2 of which are numbers, so in the 6th field I typed in
"Total:[Std Qty]*[Qty]"
Now how can I display the "Total" so I know what the calculation is?
Thanks in advance,