1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access Question Tables/Reports

Discussion in 'Business Applications' started by Kammmie, Sep 3, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. Kammmie

    Kammmie Thread Starter

    Joined:
    Aug 14, 2001
    Messages:
    132
    Does anyone know why numbers on a report would come out different than the numbers in a table?

    For example, the table is set up to show 35 as $35.00. On the report it comes out as 35 (no dollar sign or .00).

    Any reason?

    Kristy
     
  2. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    The report doesn't know that it is a currency field unless you specifically have it set in the table as such. Otherwise you have to specify in the report the format you want to see.
     
  3. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    You need to format it in the report too.
    Double-click the control to get to its properties and go to the Format tab and change it.

    Why do they do that?
    'Cause you might want your system to show mm/dd/yyyy, but you want a letter to show mmmm d, yyyy
     
  4. Kammmie

    Kammmie Thread Starter

    Joined:
    Aug 14, 2001
    Messages:
    132
    Worked like a charm. Thanks again. This project is coming along well and I'll be sure to throw credit towards the "TechGuy" forum!

    Kristy
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/269688

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice