Automatically fill IDs into sections of your tables

[ElcoyotldeAztlan]

Hello Everyone,

Is there a way to have a query to fill a section of your columns in your tables with the same ID? for example,

If I have a table with 300 different types of Doors that all have different material types can I automatically or have a shortcut where doors 1-100 are fill in as metal or ID 1 from the Material Table. then could I put doors 101-300 as ID 2 (Wood from Material tables). This would reduce alot of time instead of inserting ID 1 a hundred times or any ID multiple times for that matter

So in theory,it would be like selecting column 1 to 100 and once all those cells are highlight we can paste 1 in those all 100 cells ?

Any ideas? maybe there are other shortcuts then a Query?
Thanks

 

[plog]

Could you demonstrate what you want to occur with data? Provide 2 sets:

A. STarting sample data from all your tables. Include table and field names and enough data to cover all cases.

B. Expected results from A. Show what data you hope to end up with when you feed this query the data from A.

The main issue I am having is how you are determining the order of your Doors. What field makes a door the 1st door, what makes a door the 135th door? Have an ID field that you are using for that?

 

[ElcoyotldeAztlan]

right now the doors are just the ID numbers no specific names

if I have a door Table with 300 doors that uses the material ID from another table like so, (not all the doors have a material Id that needs to be filled)

Table 1
DoorID | MaterialID
1 | 1
2 | 1
3 | 1
4 | 1
............
..............
101 | 2
102 | 2
..........
.............

Table 2
MaterialID| MaterialType
1 |Metal
2 | Wood


How could I make it quicker for me to fill in 103-200 all as 2
thats my question

 

[plog]

Please demonstrate your issue with data. You've tried twice to explain it with data, now I need you to show me with data. No more explanations--just 2 sets of data--before and after. See my first post for more information.

 

[ElcoyotldeAztlan]

I apologize I mis read your comment, I can not demostrarte the data because I'm new to access , I'm asking how I would perform the task

 

[plog]

Demonstrating data has nothing to do with access. I want you to give me 2 sets of data, put one on each tab of a spreadsheet:

Tab A--Starting data. Provide sample data from your table to show me what you are starting with. Provide table and field names and enough data to cover all cases.

Tab B--Expected results of Tab A. Show me what data you hope to end up with when the Tab A data is put through the process.

If you had a table of people, birthdates and genders and wanted to know everyone's woman's age on 1/1/2017, then you would provide me with your list of people, birthdates and genders on Tab A. For Tab B you would copy Tab A data, delete all the males and then add a new column for the age and go through and manually calculate their age and put it in the new column. That is what I want you to do for your data--show me what you are starting with and what you hope to end with.

 

[ElcoyotldeAztlan]

Thank you for your help I was to find select section of my table fields and insert my copy data inside