Search results

  1. H

    Form design with 4 tables = 2*2 parent/child

    Can someonehelp me with form design with 4 tables. I have 1 customers table, 1 jobs table, 1 quotes table and 1 products. Customers->1..many->Jobs Quotes ->1..many->Products And all 4 tables is connected with CustomerID. Do you have some taughts?:)
  2. H

    Using the Sum() with parent/child form

    Nice:) Thank you!
  3. H

    Using the Sum() with parent/child form

    It doesn't work. Error
  4. H

    Using the Sum() with parent/child form

    I have to fields in my subform: Quantity, Price and SubTotal In my SubTotal field i have the code: =[Quantity] * [Price] My goal is to Sum the SubTotal field for all records in a field in the main form. How can I do it? I have tried all kind of code with the expression builder. Please help:)
  5. H

    Get a query inside a text field

    Thanks for answer Do you have a sample code for the Dlookup and Dsum?
  6. H

    Get a query inside a text field

    I need to get a query who calculate Sum(). The query are working, but I cant get it to "print" out in the textfield. Why not?
View older results
Back
Top Bottom