Search results

For some reason I can't run VBA on my work computer so I exported to excel and ran this macro to get what I have now. Sub JoinThem() ' Go until blank cell (first click at upper left of range) Do While ActiveCell.Value <> "" ' If this row macthes the next row If...

Still having some issues. I'll just explain what I'm trying to do. I feel like I missing something obvious. I received raw data about AP Test Scores from Students. It comes is a raw CSV feed that I import into Access. The original CVS come is with one row per ID and a column for the 30...

Back from a long weekend. Thanks for the leads guys. I may start with the cross-tab and see if I can get where I need with that. If not I'll look at the Allen Browne link.

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...

This worked for the null error: =DLookUp("Major","Major List","Id=" & Nz([Q37_1],0)) Thanks guys!

Thanks! This works like a charm: =DLookUp("Major","Major List","Id=" & [Q37_2]) One question. If they have not requested a Major and this field is NULL, it displays #error. How do I add something to get it to ignore null? Mike

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...

Yes. No luck. Also, it definitely seems to want a table reference. Mike

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...

Awesome. Perfect. Thank you so much.

Perfect! Thank you! How would I go about removing nulls if I needed to?

I added quotes: SELECT "V4", "Q83_1_TEXT(1)", "Q83_2_TEXT(1)" FROM CollegeCredit UNION ALL SELECT "V4", "Q83_1_TEXT(2)", "Q83_2_TEXT(2)" FROM CollegeCredit; Now the query loads but it just shows the column headers instead of data. The number of rows is correct though. I think I'm close...

So my linked table is called "CollegeCredit". The courses have 5 possible fields per course (name, college, course number, grade, credits) and these are unfortunately named: Q83_1_TEXT(1) - for course 1 name Q83_2_TEXT(1) - for course 1 college Q83_3_TEXT(1) - for course 1 course number...

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...

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...

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...