Kamis, 26 September 2013

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

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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/

Tidak ada komentar:

Posting Komentar