Re: Aggregate Count of Records
From: Frank Camean (frank.camean_at_4sight.org)
Date: 09/12/04
- Next message: Frank Camean: "Re: Creating a Dashboard of Global Values"
- Previous message: Jess: "Re: Auto update a field based on another field"
- In reply to: Dirk Goldgar: "Re: Aggregate Count of Records"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 11 Sep 2004 21:02:24 -0700
Dirk,
My apologies for the double posting. I wasn't aware of
it. Thanks for bringing it to my attention. If I ever do
need to post to more than one newsgroup, I'll follow your
instructions as noted below. Thanks for your assistance.
Frank
>-----Original Message-----
>"Frank Camean" <frank.camean@4sight.org> wrote in message
>news:0af401c49872$70bb6700$a401280a@phx.gbl
>> What is the formula that can be used to display an
>> aggregate count of records and display it on a form? Is
>> it DCount? I tried but am having no luck.
>>
>> On a blank form, I've inserted a text box. On the
>> properties I've selected Expression Builder. The field
>> name on the form is TOTALCONTACTS. I want this field to
>> dispaly the total number of contacts in my DB. What's
the
>> correct formula? I keep getting #Name?.
>>
>> Any information will help. Thanks.
>>
>> Frank
>
>Please see my answer to this question where you posted it
independently
>in a different newsgroup. That's called "multiposting",
and it's
>generally frowned on because others don't know what
answers have already
>been given, and so they duplicate the effort. Also it's
harder for you
>to keep track of the various replies, and it's harder for
later readers
>of the question, who may be looking for the same answer,
to learn what
>they need.
>
>In most cases a single, well-chosen newsgroup will do.
If your question
>really is relevant to more than one newsgroup, the
approved technique is
>to "crosspost" it instead, by listing multiple newsgroups
in the To: or
>Newsgroups: line of a single message. If you do that,
the message and
>any replies will appear in all the listed newsgroups
automatically,
>which is beneficial to all concerned.
>
>--
>Dirk Goldgar, MS Access MVP
>www.datagnostics.com
>
>(please reply to the newsgroup)
>
>
>.
>
- Next message: Frank Camean: "Re: Creating a Dashboard of Global Values"
- Previous message: Jess: "Re: Auto update a field based on another field"
- In reply to: Dirk Goldgar: "Re: Aggregate Count of Records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
