Search results

Hi all, I have a subform situated in a main form, Its a db that monitors sales. The main form is based on an orders table. The subform is the order details. Within the subform are Qty, Unit Price and Discounted Price fileds. I have the form/subform working correctly when totaling the sum of...

Hi all, I've a problem. Who hasn't these days; or is it just me???? I have a form where a Date of Purchase is entered. I created a report where it is grouped by customer, then by Date of Purchase and then it lists the products sold for that date. However, it appears to be grouping by Month as...

hey...it works.. :) i replaced thae value (17.93) with the control source value....:) superb !! many thanks

hi again, thanks for the post.... the number to be rounded down, is not a fixed value, i dont know what the value is...at least unitl it has been calculated.... so in effect i want any value that is returned by the report to be rounded down to the nearest 10.... Its for a loyalty points...

apologies....:( i meant 17.93 would round down to 10 9.43 would round down to 0 if anyone could help, it would be greatly appreciated,,,,apologies for the confusion :confused: :confused: :confused:

Hi, I am quite new to access, and have the following problem:- I have a value that is returned in a report of say 17.93, i would like to round this number down to 17, similarly 9.13 should read 0 Can someone help please? Many thanks in advance :)