Search results

  1. S

    Using a sum of queried records in a calculation in a form

    Sorry, my brain assumed that was my prior email as if you replied to it. Trying it now!
  2. S

    Using a sum of queried records in a calculation in a form

    This is my current command. DSum("[Sum Of Bill Amount]","[CostsQuery]","[Forms]![Bill Reduction Wksht]![FullName]") I can't change the sum of bill amount field as that is set by access when you hit sum. The rest are changed but same problem. My query that works correctly is a joined query...
  3. S

    Using a sum of queried records in a calculation in a form

    This is my current command. DSum("[Sum Of Bill Amount]","[CostsQuery]","[Forms]![Bill Reduction Wksht]![FullName]") I can't change the sum of bill amount field as that is set by access when you hit sum. The rest are changed but same problem. My query that works correctly is a joined query...
  4. S

    Using a sum of queried records in a calculation in a form

    How would I do that if the fields I want to compare are CostQuery!Name and [Forms]![Bill Reduction Wksht]![FullName] I tried this but it gives me an error =DSum("[Sum Of Bill Amount]","[Costs Query]","[Forms]![Bill Reduction Wksht]![Full Name]")
  5. S

    Using a sum of queried records in a calculation in a form

    Thanks. That got the total of all the records, but now, although my Costs Query properly up the limited records, the Dsum still totals all the records in the costs table.
  6. S

    Using a sum of queried records in a calculation in a form

    New to Access, not to programming. I have 2 tables. Call one Contacts, the other Costs I am able to sum the costs for a single contact in a query (Costs Query)![Sum Of Bill Amount]) I want to use that sum in a field in a form (Bill Reduction Wksheet]!TotalCosts which will then calculate several...
Top Bottom