Access Report Calculation 1

[jsnull]

I am designing a report in Access that is initiated by a form. On the form I input a quantity into a text box. Then when I click the command button I want the report to list out quan, description, style where the quantity is equal to the amount in the database times the quantity input into the text box. I'm having a bit of a struggle coming up with the syntax to get it to work, everything I've used has failed or returned a zero value.

varNewQuantity = fieldquantityindatabasequery * txtQuantity

thanx!

Jim Null

http://www.jimnull.com

 

[randy700]

Something like...

"SELECT quan * " & Forms!FormName!txtBoxName & " As NewQuan, description, style FROM yourTable "

Randy