Re: Displaying an Access Percentage

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Mar 6, 1:29 pm, "Kathleen Anderson [MVP - FrontPage]"
<spiderwebwo...@xxxxxxxx> wrote:
"frontpagecustoms.com" <m...@xxxxxxxx> wrote in message

news:1173200051.568977.160490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On Mar 5, 1:27 pm, "Kathleen Anderson [MVP - FrontPage]"
<spiderwebwo...@xxxxxxxx> wrote:
"frontpagecustoms.com" <m...@xxxxxxxx> wrote in message

news:1172946591.674606.244190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I appreciate your time and have been working to implement the code you
sent me. However after putting that code into the Custom Query windos
in the DBRW I received the following error:

Database Results Wizard Error
Description: No value given for one or more required parameters.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

I'm curious if I'm missing something or if I put it in the wrong place.

First, please include the full text of the post you are replying to - it
makes it easier to follow the thread.

SELECT Company,Format(Total1YrPctInc,'##0.00##%') as
newTotal1YrPctInc,STL1YrPct,BGMC1YrPct,TotalGiving,TotalGivingPrevYear
FROM
studentMissionsGiving06 ORDER BY Total1YrPctInc DESC

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/

Thanks! It works. I appreciate your time an patience as you helped
me out.

Do you know if I have to do a custom query every time I want to
format? Can I enter the formatting code into the Database Results
Region Wizard in the SQL statement?

If you are creating a new field as a result of the FORMAT, you should do it
in the Custom Query window that is available to you while you are running
the wizard.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/

Thanks.

.

Relevant Pages

  • Re: Displaying an Access Percentage
    ... Microsoft MVP - FrontPage ... Spider Web Woman Designs ... Do you know if I have to do a custom query every time I want to ... If you are creating a new field as a result of the FORMAT, ...
    (microsoft.public.frontpage.programming)
  • Re: Format of addresses in personal letters
    ... please post all follow-ups to the newsgroup so ... it is not a standard MS format thats for sure. ... >> Microsoft MVP ... Several lines of typing in each address ...
    (microsoft.public.word.newusers)
  • Re: Template Resets Itself
    ... > template into the document each time you open the document. ... > "Suzanne S. Barnhill" wrote: ... >> it's possibly you're saving in a text format instead of Word format. ... >> Microsoft MVP ...
    (microsoft.public.word.application.errors)
  • Re: Setting field properties in code
    ... References on the Tools menu, ... (BTW, the Format property is a Text type, regardless of the type of field.) ... >> Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (comp.databases.ms-access)
  • Re: Mixing numerical and alphabetical outline numbering
    ... You an insert static text in the number format box in Format | Bullets and ... Microsoft MVP ... please post all follow-ups to the newsgroup so ... > we have to accommodate a static letter as part of our outline numbered ...
    (microsoft.public.word.numbering)