User Profile

Collapse

Profile Sidebar

Collapse
AccessLearner73
AccessLearner73
Last Activity: Oct 23 '16, 10:58 AM
Joined: Aug 29 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • AccessLearner73
    replied to Minimum Value (Date)
    in Access
    they are like buy date, sale date, delivery date & are in the same record set. I am getting this into a query & want to create a new field in query itself to get me smallest date out of all these dates.
    See more | Go to post

      Leave a comment:

    • AccessLearner73
      started a topic Minimum Value (Date)
      in Access

      Minimum Value (Date)

      I have 6 date fields in a query record & want to create one field to access smallest date value in each record.

      Please help on building expression.
      See more | Go to post
      • AccessLearner73
        replied to Hide a Row @ Report ( Access 2010 )
        in Access
        Thanks ZMBD.

        I am sure Phil is trying to help me but after adding Option Explicit to code i am getting errors i don't even know what to do with them. Still struggling. Hope it works.
        See more | Go to post

          Leave a comment:

        • AccessLearner73
          replied to Hide a Row @ Report ( Access 2010 )
          in Access
          Hi,

          DB enclosed
          report name is Qr_Rpt_SiteList...
          See more | Go to post
          Last edited by AccessLearner73; Aug 30 '16, 12:58 PM. Reason: no atachment

            Leave a comment:

          • AccessLearner73
            replied to Hide a Row @ Report ( Access 2010 )
            in Access
            Adjusted but no effect. Problem lies with Utilization
            I removed the field & rest was working perfectly.
            See more | Go to post

              Leave a comment:

            • AccessLearner73
              replied to Hide a Row @ Report ( Access 2010 )
              in Access
              Hi,
              Yes Report Detail Can Shrink & Can Grow are set to "Yes".

              The right column is Utilization2 to Utilization6, as i actually have 5 rows to hide/show depending on data in there. in my question i have mentioned row 2 only to keep it simple.

              I'v now replaced combos with text box & visible=false is working but for last column "Utilizatio n2" it's not working. It's a numeric field does that...
              See more | Go to post

                Leave a comment:

              • AccessLearner73
                replied to Hide a Row @ Report ( Access 2010 )
                in Access
                Thanks Phil,

                Did that all but no effect at 2nd row. It remains there.

                Please refer to attached images.

                Regards.
                SAM
                Slide1:
                [IMGnothumb]https://bytes.com/attachment.php? attachmentid=88 69[/IMGnothumb]
                Slide2:
                [IMGnothumb]https://bytes.com/attachment.php? attachmentid=88 70[/IMGnothumb]
                Slide3:
                [IMGnothumb]https://bytes.com/attachment.php? attachmentid=88 71[/IMGnothumb]...
                See more | Go to post
                Last edited by zmbd; Sep 7 '16, 03:21 AM. Reason: [z{inserted images inline}]

                  Leave a comment:

                • AccessLearner73
                  started a topic Hide a Row @ Report ( Access 2010 )
                  in Access

                  Hide a Row @ Report ( Access 2010 )

                  Hi,

                  Im trying to hide a rows where there is now value.

                  Data is coming from a query.

                  Row 2 of detail section has 3 fields ( Site2, SitName2, Utilization2)

                  I need to hid this row if site2=null & sitename2 = null & utilization2=0

                  Thanks for help.
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...