Re: Exporing Numbers from a query

From: Chris (anonymous_at_discussions.microsoft.com)
Date: 03/23/04 

Date: Mon, 22 Mar 2004 20:50:22 -0800

Thank You Cheryl but I am still confused on where to put
this expression. Some fields are built on expressions in
the Zoom box. Can you give a more detailed description on
how to export the field.

Thank You

Chris
>-----Original Message-----
>You can export this field as CInt([MyField]) or CLng
([MyField]) in your
>query. A quick test here showed that there were no
decimal places when a
>query using either of these functions was exported to
HTML.
>
>--
>
>Cheryl Fischer, MVP Microsoft Access
>Law/Sys Associates, Houston, TX
>
>
>"Chris" <anonymous@discussions.microsoft.com> wrote in
message
>news:11c4701c41047$67ee4f10$a101280a@phx.gbl...
>> I have a query that gives me the total points with zero
>> decimal places(the whole number)like 300, 450. The
problem
>> is when I export the query to html I get 300.00, 450.00
>> with 2 decimal places. I tried making changes in the
table
>> properties and nothing seems to work. I am opening it up
>> in Front Page as well. Iif I can make changes there that
>> would be great also.
>>
>> Any Suggestions
>>
>> Chris
>
>
>.
>

Relevant Pages

  • Re: Exporing Numbers from a query
    ... query using either of these functions was exported to HTML. ... "Chris" wrote in message ... I tried making changes in the table ...
    (microsoft.public.access.externaldata)
  • Exporing Numbers from a query
    ... I have a query that gives me the total points with zero ... I tried making changes in the table ... Chris ...
    (microsoft.public.access.externaldata)
  • Re: Grandma????
    ... Congratulations to all concerned, both for the anniversary and the expected arrival. ... In message, Cheryl writes ... They invited family (Chris and Amber, ... cardboard - corsage type boxes. ...
    (rec.crafts.beads)
  • Re: Append problem
    ... Cheryl Fischer, MVP Microsoft Access ... "Basil" wrote in message ... > The code you suggested gives me the error "Query input must contain at least one table or query." ... > Cheryl Fischer, MVP Microsoft Access ...
    (microsoft.public.access.queries)
  • Re: OT Kinda - BIG Thanks to Heidi
    ... Cheryl in Oz wrote: ... query to Amazon in Germany. ...
    (rec.crafts.textiles.quilting)