Kamis, 26 September 2013

Re: [MS_AccessPros] Separator / comma for row count field

 

Hmm... I don't know is that is good or bad news.
I should say, the totals at the end of the report also respond that way.
Mysterious.
Maybe I have a 2007 issue. I will look into that more,
You are helpful though; to know that is often the solution makes it less despairing!
Thank you,
Patty

Sent from my mobile device

On Sep 26, 2013, at 7:22 PM, Duane Hookom <duanehookom@hotmail.com> wrote:

> I just did a test in Access 2010 with a text box in the Group Footer with these properties:
>
> Control Source: =Count([LastName])
> Format: Standard
> Decimal Places: 0
>
> My numbers appear exactly how expected.
>
> Duane Hookom MVP
> MS Access
>
>
> ----------------------------------------
>> From: patty.mapes@gmail.com
>>
>> 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.
>>
>>
>>
>> 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 (7)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar