Search results

  1. P

    Getting a date from Query to Text box

    I have a query that returns the latest order date of a customer (on a sub form). I want to get the value from this query into the main form. The idea being that everytime the customer adds a new order this value would be updated. How do i do this?
  2. P

    Delete old orders query

    I want to write a query that would delete records from 3 linked tables Customer has Orders that have Items The Order table holds the date of the orders. I want to delete all customers that have not placed in order since a user entered date. Not got off the ground on this one. Any help...
  3. P

    Getting data from Sub Form to Main

    I have calculated the SUM total of a cost in an order form (e.g has 3 items). How do can i transfer the data to a Total field in the main form (i.e main form holds the total cost of items)? Table details Main Form (Orders1 with field name Order Value) Sub From (Items1 with field name...
  4. P

    transfering data from sub form to form

    how can i calculate the SUM total of a cost in an order form (e.g has 3 items) and transfer the data to a Total field in the main form? Badger
Back
Top Bottom