help!!!!! (1 Viewer)

[Milan]

posted 03-08-2002 10:16 AM
--------------------------------------------------------------------------------

HI !! I HAVE A QUERY BELOW -:
BASICALLY ALL I AM DOING IS GETTING THE RESULT BASED FROM A FORM , TXTBOX NAMED TXTCOST. IF I PUT "ALL" THEN IT RETURNS ALL THE RECORDS IN THE QUERY , AND IF I SPECIFY A PARTICULAR VALUE I.E 100 THEN IT RETURN EVERYTHING AT 100. ALL WORKS GREAT. HOW CAN I GET THE QUERY TO RETURN A VALUE THAT IS GREATER THEN. SO FOR EXAMPLE I WOULD ENTER IN THE TXTCOST CONTROL ">100" AND WOULD RETURN EVERYTHING GREATER THEN 100. I WOULD OBVIOUSLY LIKE TO STILL KEEP THE EXISTING "ALL" SEARCHES AND SPECIFIC VALUES THAT ALREADY WORK.. WHAT DO I NED TO ADD THE THE EXPRESSION???.
Like IIf(([invoicelines]![EXTENDEDPRICE])=IsNull([Forms]![FrmVehicleEnquiry]![Txtcost]) Or [Forms]![FrmVehicleEnquiry]![TxtCost]="All","*",[forms]![FrmVehicleEnquiry]![TxtCost])

Thanks

Milan

 

[Pat Hartman]

You can't change a relational operator on the fly. The only way to do this is to build the query in code.