Sabtu, 28 September 2013

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

 

Thank you Bill. I'm going to try that.
Patty

Sent from my mobile device

On Sep 28, 2013, at 12:22 PM, "Bill Mosca" <wrmosca@comcast.net> wrote:

 

Patty

 

In the past, I have had issues with number formatting especially when using SQL Server linked tables. If you are still having trouble try forcing the formatting like this:

 

Control Source: =Format(Count([LastName]),"0,000")

 

Regards,

Bill

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Patricia Mapes
Sent: Thursday, September 26, 2013 5:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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 (9)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar