can this be done by a query or?

[ariansman]

Student lectures, subjects and locations are stored in a table like this and now we are in record ID number 154.

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            Geography

We know that the next 32 lectured will be presented by jack on politics ,but we don’t know about the exact location(lectureplace). Can we instantly fill the next 32 records with the data that we know, such as student name and subject, but the lectureplace is left blank and it will be filed later when we know about the location? The resultant table will have ID from 155 to 187, stunetname:jack, lecturesubject: politics but the location will be filled later when the place of the presented lecture is known .
Please lets forget if this job makes sense or not, and lets think if this is possible to be done.
Thank you

 

[ChristopherL]

Can't you just make an update query that only updates the values for the certain ID that you want to update?

 

[ariansman]

those IDs (155 - 187) have not yet been created yet. they are supposed to be created automatically when the query puts the data in. will this "update query" do that? how can i make an "update query" then?

 

[ChristopherL]

those IDs (155 - 187) have not yet been created yet. they are supposed to be created automatically when the query puts the data in. will this "update query" do that? how can i make an "update query" then?

You can make an append query for (155-187). When you append and leave a column blank you can update that column with an update query.

If you've never created an update or append query before. Just go to youtube and search for access update/append querys and you will quickly get a hand of it!