-
Access Query Expression Help
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|