Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Append query to unknown table

Append query to unknown table

Append query to unknown table

Good morning all. As usual I have an issue. I have an ACCESS DB to analyze missed questions from tests. I have a table of all the question identifiers for each test

The tests, when taken, are scanned and graded by an external application (not Access). The instructor then exports a csv file to my drop box. The file contains the quesions, 1,2,3,4,etc...horizontally and the students 1, 2, 3, 4, etc vertically. The matrix shows a 1 for correct answers and a 0 for incorrect answers. So this is just a list of numbers horizontally and vertically. The name of the file contains the Exam identifier information. I import the file into a table using the file name as the table name.

I then run a query on that table summing all the missed questions. I now need to append the results of the summing query to the correct question identifiers table...but how do I select the correct table automatically. Remembering the importated table name contains the test identifier number I broke out the information with a query.

So, I now have each question summed for misses answers. The question numbers 1, 2, 3, 4, etc are in the correct order where they could be appended to the correct question identifier table. I also know the identification information, from the import table name, of the question dentifier table. How do I write VBA for an append query to the identified question identifer table using my sum table information.

Sounds confusing but because the export from the grading application only contains numbers I have to have some way to relate the number of misses to actual question identifiers. Export: Questions 1 - 2 - 3 - etc. Actual question identifiers look like 824-00 1, 824-10 20, 824-10 21, etc.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close