report query using VB

[kabir_hussein]

Hi i am trying to do a report for orders that are less than 1.

The textbox that does the calculation does not belong to a table. it is purely for the report. I have added the textbox to the report for other reasons.

Does anyone know how i would need to write some code for the report to only show list of items that are below 1

below is how the report looks like, i have asked a similar query but reaslised it was a bit complicated

 

[Pat Hartman]

Do the calculation in the query and use it as selection criteria.

 

[kabir_hussein]

Hi Paul

this might sound but i thought u couldnt do calculations on queries.

if so how would you do it

thanks

 

[Pat Hartman]

Select ((fld1 * fld2) + fld3) as calcFld from yourtable;