Re: Query Results- Incorrect formatting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 08/26/04 

Date: Fri, 27 Aug 2004 09:31:46 +1000

Try setting the Format of the Query Column / Field to "#.00". In the
DesignView of the Query, select the required Field and open the Properties
window. There should be a "Format" row in the Properties window for you to
enter the format. 

-- 
HTH
Van T. Dinh
MVP (Access)
"Mark Senibaldi" <MarkSenibaldi@discussions.microsoft.com> wrote in message
news:021F6EC4-7BB9-4A4F-8097-14B68EDA3C98@microsoft.com...
> Hi,
>
> I have a query that is summing up column A which is formatted as
> Number-Double in it's current table.  The results of the query should show
up
> as 0, but they are showing up in scientific format- All of the other
records
> are showing up correctly in this same query.  I even tried the following
> Val(format([tablename].[fieldname],"#.00")) and this gave me the same
results.
> Any help would be appreciated.
>
> Thank you.
> -- 
> MSS

Relevant Pages

  • Re: Multiple date formats in a Table
    ... Duplicating the date in a second date field is certainly one way of doing ... window, then click on "New". ... Once you've got a function that works, create a new query in design ... > with date format and field properties. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: formatting a calculated number field on a form
    ... > A query in an MDB file CAN call a user-defined function. ... > function name is Age and it returns a double. ... The user will certainly "notice" if a patient was born on Jan ... I just want control over the *display format* of a number ...
    (microsoft.public.access.forms)
  • RE: Query count then average.
    ... What was happening in my database was the query returned the ... "Ken Sheridan" wrote: ... It probably depends where you set the Format property. ... "Robert F." ...
    (microsoft.public.access.queries)
  • Re: Convert text string to number in a query
    ... I want to run a query that converts the text from the field into a number, ... albeit it was in number format. ...
    (microsoft.public.access.queries)
  • RE: Cannot get code to work for API Save Dialog Box
    ... I got it working to format correctly now. ... that table in my other queries and union query. ... The code is actually working by giving me the totals I need. ... The first spreadsheet placed where I told it to be contains the incorrect ...
    (microsoft.public.access.forms)