I got this report from a client. Many of the counts are in the tens of thousands. I wanted to format the numbers to include the comma separators for thousands to make the numbers more readable.
Sent from my mobile device
On Sep 26, 2013, at 6:32 PM, Duane Hookom <duanehookom@hotmail.com> wrote:
> Patty,
>
> So your control source is something like:
> =Count([SomeFieldName])
>
> What do you mean by "does not work".
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
>> From: patty.mapes@gmail.com
>>
>> It is the count of records in a grouping? On the report; make sense?
>>
>> Sent from my mobile device
>>
>> On Sep 26, 2013, at 6:17 PM, Duane Hookom <duanehookom@hotmail.com> wrote:
>>
>>> Patty,
>>>
>>> What is the control source property of your "row count field"? Are you using a running sum property of the control or is this value from the record source?
>>>
>>> Duane Hookom MVP
>>> MS Access
>>>
>>> ----------------------------------------
>>>> From: patty.mapes@gmail.com
>>>>
>>>>
>>>> I have a report with a row count field in it. I would like to use a standard format, with no decimal point and a comma/separator. I have zero in the decimal places in the property sheet and that works fine. Using "Standard" in the format box in the property sheet does not work.
>>>>
>>>> I appreciate any suggestions.
>>>>
>>>> The database I'm working on is 2007, and I have 2010 on this machine.
>>>>
>>>> Patty
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar