Recent content by mabiem

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