how to compile this table?

ariansman

Registered User.
Local time
Today, 01:12
Joined
Apr 3, 2012
Messages
157
Table ‘studentlectures’ is comprised:
Code:
ID   studentname    lectureplace       lecturesubject
1         jack           A             politics    
2         steve          A             politics    
3         jack           B             math    
4         steve          A             politics    
5         jack           B             politics    
6         joe            A             politics    
.
.
154       Jane          B               politics

I have created a form named “students” and a blank on this form named “studentname”, from where I can select a student name and put [forms]![Students]![studentname ] in the criteria of a query named "query1", to show the records for a specific student. So far, so good.
Because of a reason, I need a table to be compiled with the result of the above query. I don’t need a query but a table. The table should be compiled to show the records of a specific student whose name is selected from the above mentioned form. Is this possible by VBA or a Query. I am so novice and understand only basics of access. I would appreciate if you could provide the VBA or SQL code to make this table created.
Thank you
 
Transform your query into a Make Table query.
 
I don’t need a query but a table
To Access, queries and tables are interchangeable for most operations. What are you going to do with the table you create? If you want to export it, just export using the query. The query can take parameters so you export the rows for one student at a time if that is what you need. If this doesn't solve your problem, please tell us what you will be doing with the data that you think requires a table.
 

Users who are viewing this thread

Back
Top Bottom