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

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/