User Profile

Collapse

Profile Sidebar

Collapse
J Hall
J Hall
Last Activity: Mar 6 '11, 01:54 PM
Joined: Aug 29 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • J Hall
    replied to Access 2003. Count text from records of checked boxes.
    in Access
    Thanks for your reply,
    As a very new user of Access,I guess my current homework is to learn more about subqueries. I'll be studying.
    See more | Go to post

      Leave a comment:

    • J Hall
      started a topic Expression Help
      in Access

      Expression Help

      I have a query set up with a list of records with check box fields, Text boxes and one text field with numbers.

      I used this expression to get the sum total of [Text box with numbers] per total records by counting [Text Box A]

      =Sum([Text Box with numbers])/Count([Text Box A])

      80/21=3.81



      Now I want the total of [Text box with numbers] per records with [Check Box A] checked....
      See more | Go to post
      • J Hall
        replied to Access 2003. Count text from records of checked boxes.
        in Access
        Well,
        I've been trying for a couple of days, but I'm just not getting this one.

        I'm working expressions from the report. I have FieldA and FieldB set up.

        Now not to sure about third field. I tried entering the field name in your example for FieldA and FieldB and I tried entering the expression for FieldA and FieldB. I guess I'm not sure what goes in the FieldA and FieldB spots.

        Hope that make...
        See more | Go to post

          Leave a comment:

        • J Hall
          started a topic Access 2003. Count text from records of checked boxes.
          in Access

          Access 2003. Count text from records of checked boxes.

          Here is one I've been struggling with for a couple of weeks.

          On a report I have a query that has records with both Check box fields and Test Fields.

          I was able to get a sum of all the records in that query that had the text "GAMC" in the two text fields [Pl Ri Ki] & [Pl Lt Ki] by using

          =Sum(IIf([Pl Rt Ki]="GAMC",1,0))+S um(IIf([Pl Lt Ki]="GAMC",1,0) )

          Now...
          See more | Go to post
          • J Hall
            replied to Access 2003. Count check boxes in multiple fields.
            in Access
            Thanks Ali, I just had to remove the = before the first IIf and it worked

            =sum(IIf([A]=0 And [b]=0,0,IIf([A]=0 And [b]=-1,0,IIf([A]=-1 And [b]=0,0,"1"))))

            Now here is another one I've been struggling with for a couple of weeks.

            On another report I have a query that has records with both Check box fields and Test Fields.

            I was able to get a sum of all the records in that query...
            See more | Go to post

              Leave a comment:

            • J Hall
              started a topic Access 2003. Count check boxes in multiple fields.
              in Access

              Access 2003. Count check boxes in multiple fields.

              Access 2003.

              I have a query which pulls in a list if ID numbers with about 6 check box fields. In my report, I need to know how to count the number of ID numbers that have 2 or more of the fields checked.

              Example:
              There are (3) ID numbers listed that have Field A and Field B checked. How do I get the (3) to show in my report?

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