Re: DlookUp & then adding various fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

=?Utf-8?B?TmV3Ymll?= <Newbie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:00A08A6D-6B60-4DA0-A07B-A452DE9D11A1@xxxxxxxxxxxxx:

> What i want to do is to total the values together and
> use it in a text box on a form as a grand total for the department.

DSum("NumOfParts", "MyAnatomyTable", "PartsToBeCounted = TRUE")

You can just put the expression into the Controlsource property of the text
box in design view, so you don't need a query or any code!

Hope that helps


Tim F

.

Relevant Pages

  • Re: comapre 2 col.
    ... You can do this using conditional formatting: ... Tim ... >i want to know if there is any solution for this query. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Relational Tables plus some
    ... A Mail Merge can - and should - be based on a Query. ... necessary, nor desirable, nor good design, to store this calculated ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Re: New to Oracle
    ... Wondering if someone can help educate me on the design on query ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • Re: New to Oracle
    ... Wondering if someone can help educate me on the design on query ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • RE: Date range in query
    ... I am trying to design a query for a quarterly report. ... Prev by Date: ...
    (microsoft.public.access.queries)