Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Supress field and show some too (Access2003)

    Data should look like this

    Region______City_______Job__________Grade________N ame
    East________PHL______123___________A___________And kjsnfd
    ____________LAX________________________________Emn firjefkj
    ______________________122__________B__________ Rfknvjkfdkj
    West__________________134__________B___________Rmf knnvbn

    I have each field sort by and grouped by.
    Duplicates are hidden.
    Trouble is to show a Grade per each visible job - duplicate or not.
    Right now I would not have second B shown. Because it is a duplicate.
    If i show duplicates - I will see second A which i don't want because job is the same and is supressed.

    Please, help!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Supress field and show some too (Access2003)

    It's reasonable that the second B is not hidden - it may be the same as the value above, but it's in a different group. But if you really want to hide it, either reduce the height of the group headers to 0 or turn off the group headers (similar for the group footers).

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Supress field and show some too (Access2003)

    Right now you are getting ... what?

    If you want the report to be displayed as in the first post in this thread, make sure that you have a group header for the Job field and that the height of this header is not 0 (it can be very small though).

  4. #4
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Supress field and show some too (Access2003)

    Sorry I had not explained it correctly.
    Example is how I want it to be displayed.

    Region______City_______Job__________Grade________N ame
    East________PHL______123___________A___________And kjsnfd
    ____________LAX________________________________Emn firjefkj
    ______________________122__________B__________ Rfknvjkfdkj
    West__________________134__________B___________Rmf knnvbn
    _______________________________________________Brg rgjejbb b

    Right now I am getting this:

    Region______City_______Job__________Grade________N ame
    East________PHL______123___________A___________And kjsnfd
    ____________LAX________________________________Emn firjefkj
    _____________________122___________B__________ Rfknvjkfdkj
    _____________________222______________________ Rfknvjkfdkj


    The Grade for the Job 222 is also B so it gets supressed.
    I need to see grades IF the job number is different.
    However I can't achieve this.
    OK, maybe summary should be that
    If I am supressing dups - it suppressing dups grades for different jobs.
    I need to SEE same grades if jobs are different.

    Sorry for the confusion and thanks

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Supress field and show some too (Access2003)

    The second part of my previous reply remains the same.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Supress field and show some too (Access2003)

    Sorry I was editing and had no idea you are here. :-))

  7. #7
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Supress field and show some too (Access2003)

    Now I am seeing all the fields I wanted to supress even those are marked like supress YES.

    Edited:My data is in Details.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Supress field and show some too (Access2003)

    I'd have to see (a stripped down copy of) the database if you want more help.

  9. #9
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Supress field and show some too (Access2003)

    Sending. Thanks

  10. #10
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Supress field and show some too (Access2003)

    i'VE STRIPPED IT TO THE 1 TABLE WITH 2 RECORDS AND 1 rEPORT AND IT IS STILL ZIPPED 133KB.

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Supress field and show some too (Access2003)

    Try saving the database in Access 97 format (Tools | Database Utilities | Convert Database | To Access 97 File Format) and zipping the resulting file.
    Or create a blank new database and import tthe table and report into this new database (File | Get External Data | Import), then zip the new database.

  12. #12
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Supress field and show some too (Access2003)

    Post deleted by MS_fan

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Supress field and show some too (Access2003)

    Your table has two records with the same Grade but different Hrs_Job_Opening_ID values, so Grade is *not* suppressed (hidden) in the second record. That's what you wanted, wasn't it?

    If you want the duplicates for Region to be suppressed but not those for Grade, I don't think there's an easy solution for that if you have all controls in the detail section.

  14. #14
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Supress field and show some too (Access2003)

    Everything is fine except first 3 fields needs to be only seeing onse.
    Where do i have to place it if not in Detail?
    I have no idea how can I explain that 'not possible' to my boss (insert crying histerically icon):-)

  15. #15
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Supress field and show some too (Access2003)

    I am placing it in the Name section and it is still showing...

Page 1 of 2 12 LastLast

Posting Permissions

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