Search results

  1. M

    Multiple Rows -> Columns

    I have a Table/Query that looks like: Student ID AP Course Grade 112233 ENGL A 112233 FREN B 456789 HIST C 456789 ENGL A 345432 SPAN C I...
  2. M

    Form Field Referencing another table

    I have a linked table that i'm displaying individual questionnaire responses via a form. Most of the "responses" in this table make no sense, they are numerical. I can use "IIF" commands to display say the 1 as "no" and the 2 as "yes" or whatever the case is. I have one field that is...
  3. M

    IIF Statements in SubForms

    Hi, I have some linked tables I'm using as subforms. I'd like to make the data a little more readable rather than numbers that my linked table spits out (can't do anything about it). In my main form I can use the control source and enter something like this...
  4. M

    Summing Columns into multiple Rows

    Hi All, I have a linked table. The table looks like: Course 1 Name | Course 1 Grade | Course 2 Name | Course 2 Grade | Student 1 Student 2 Student 3 I need to write a query that will consolidate all the courses (15 total) into multiple rows like this: Course...
  5. M

    Filter By SubForm Date Field

    Hi, I have a form that is based on a linked table of students eligible to complete a online survey. Within that form, I have a sub form (based on another linked table) of students who have completed the form and at what date and time. Only about 1 in 10 eligible students complete the form...
  6. M

    Update Fields In Database View?

    I have what I thought was a single issue. Essentially I have two linked tables (uneditable). They are linked by PersonID and they also have email address in common. For sake of example let's say one table has names of people, and the other table has the address they live at. I have a user...
Back
Top Bottom