Hi everyone ,
Hope all is well with you guys and girls
I saw someone had a similar posting in this forum and need some help also with a Access Query Expression.

I need an expression to state the following

If Field 1 is greater or equal to Field2 then make Field3 Equal $1.00 and Field 4 equal $0.00


Also a sql Statment to show Numbers rounded to 2 decimal places . I am using frontpage 2000 and am pulling the data from access but i need a sql statment to show some of the fields rounded to 2 .decimal places.


Thanks in advance to who ever can help me