Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Aug 2002
    Location
    Kankakee, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Null data records (A2K)

    I have a time card database, which uses 2 sets of 3 weeks of data. When I print my reports, if the second "week 3" has no data, the total hours for that week still prints as "0.00". How do I tell my report that if there is no data entered for this week (if the Total Regular Hours = 0), then don't print anything for the 2nd "week 3"?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Printing Null data records (A2K)

    It is difficult to answer without a better idea of your data structure, and the underlying queries. I would probably use something like
    IIF(fielda+fieldb+field3=0,"",fielda) in the underlying query. However if you subsequently do arithmetic on the result this may cause problems. You could use Null instead of the "".

    You could also put the formula in the report form itself.

    If you need more detailed advice you could post a slimmed down version of the database so we can see what the structures are.
    David Grugeon
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •