User Profile

Collapse

Profile Sidebar

Collapse
JHamrick
JHamrick
Last Activity: Mar 13 '12, 12:26 PM
Joined: Feb 9 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JHamrick
    replied to ColumnHistory to display on report
    in Access
    What more info do you need? Any explanation on how to use the ColumnHistory function to display results on a report?
    See more | Go to post

      Leave a comment:

    • JHamrick
      replied to ColumnHistory to display on report
      in Access
      The "Comment" field is a memo type.
      See more | Go to post
      Last edited by NeoPa; Mar 8 '12, 12:43 AM. Reason: Removed quote.

        Leave a comment:

      • JHamrick
        started a topic ColumnHistory to display on report
        in Access

        ColumnHistory to display on report

        I am using this code to track and display historical entries entered into a "Comments" field everytime a user adds comments to a record. The field is a memo field with Append Only property set to Yes. This code works fine when used as an unbound field on a form, but I keep getting an #Error when displaying it on a Report. My intent is to have the historical entries display on a report as well. The report source is a query, so it is only...
        See more | Go to post
        Last edited by NeoPa; Mar 8 '12, 12:42 AM. Reason: Added mandatory [CODE] tags for you
        • JHamrick
          replied to Sum Nested IIFs in Access 2010
          in Access
          Awesome it works! Thanks. It just takes another set of eyes to see through your self-induced confusion.
          See more | Go to post

            Leave a comment:

          • JHamrick
            replied to Sum Nested IIFs in Access 2010
            in Access
            ---
            Your suggestion worked for the weight totals! I put a Sum in front since it was in the footer section and it works like a champ. I assumed that since I used multiple IIFs in the statement that they were "Nested".

            Now how can I "Count" the number of times "CBOL - N/A" is listed in all the 6 fields? Can I use the same code and put a count instead of a sum? When I try it returns "0"...
            See more | Go to post

              Leave a comment:

            • JHamrick
              replied to Sum Nested IIFs in Access 2010
              in Access
              Sorry for the confusion. Yes I had taken out the counts after I posted this question (sorry). I have even added each field (or expression) in increments to test where it stops working. I can get to this point and it calculates fine.

              =Sum(IIf([Chute#1]="CBOL - N/A",[Pallet#1Lbs]/2000))+(IIf([Chute#2]="CBOL - N/A",[Pallet#2Lbs]/2000))

              But when I add the next field (Chute#3) the results are blank. Based...
              See more | Go to post
              Last edited by JHamrick; Feb 9 '12, 07:12 PM. Reason: add

                Leave a comment:

              • JHamrick
                started a topic Sum Nested IIFs in Access 2010
                in Access

                Sum Nested IIFs in Access 2010

                I am trying to sum the following and keep getting either wrong totals or a blank.

                =Sum(IIf([Chute#1]="CBOL - N/A",[Pallet#1Lbs]/2000))+(Count(I If([Chute#2]="CBOL - N/A",[Pallet#2Lbs]/2000)))+(Count( IIf([Chute#3]="CBOL - N/A",[Pallet#3Lbs]/2000)))+(Count( IIf([Chute#4]="CBOL - N/A",[Pallet#4Lbs]/2000)))+(Count( IIf([Chute#5]="CBOL - N/A",[Pallet#5Lbs]/2000)))+(Count( IIf([Chute#6]="CBOL...
                See more | Go to post
                No activity results to display
                Show More
                Working...