Recent content by AccessNoob67

  1. A

    Query to Calculate percentages of specific records in a table

    Table 1:Students Fields: StudentID ClassName StudentName StudentEmail OnTime (0/1) Tardy (0/1) Missed (0/1) Table 2: Professors Fields: ProfessorID StudentEmail Joined on the student email. And FYI...I was handed this thing and asked to get some reporting out of it. I'm not a DB guy so this...
  2. A

    Query to Calculate percentages of specific records in a table

    Hello all, Not an Access expert, so please bear with me. I have a table that contains student names, class names, and whether or not the student was on time, tardy or a no show for a given month. I'm able to get a percentage of on time, tardy and no shows for the entire month without a...
  3. A

    Opening report and passing value from form combobox

    Thank everyone. Was able to get it figured out with all the pointing in the right direction.
  4. A

    Opening report and passing value from form combobox

    Okay...so that would be something like putting the form name and the combobox name in the criteria field?
  5. A

    Opening report and passing value from form combobox

    Like I said....total Noob. Okay....so better practice is to open the form, select the value from the combobox, and then click a button that will open the report and pass the value. How do I do that?
  6. A

    Opening report and passing value from form combobox

    Hello all, Complete access noob so please be gentle. I have a report, a query and a form. The query requires a criteria to be entered in order for the report to be populated. Right now if I open the report I get the box to type in the criteria, as to be expected. What I would like to happen...
Top Bottom