Search results

  1. S

    Calculating totals in a subform and writing to a form

    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...
    • saymo
    • Thread
    • Replies: 0
    • Forum: Forms
  2. S

    Group by day

    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...
  3. S

    rounding down to the nearest 10

    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 :)
Back
Top Bottom