Hello,
I'm sort of new to creating Access queries and would like to see if I can get some help. I would like to know if it's possible to create a query to pull similar data sets from the same table or do I need to create a secondary query first. Below is my problem:
The main table is called "tblSample". Within the table, there's 3 columns I want to pull the data from and it's called "TypeCode", "ControlNo", and "Year". Within "TypeCode" column, there's a large set of key codes, but I mainly need to find all codes that are "1501" or "1502" which stands for replacements (this part I got). "ControlNo" column shows the original item number (ex: 123456). If there's an item that got replaced, a new entry should've been created, but an "I" or "F" was added to the end of the Control No (ex: 123456F) and the type code would be "1501" or "1502".
I need help on how to create a query where I can pull all replacement item "ControlNo" and also show the original item "ControlNo" associated with it because I need to make edits to the "Year" column of the replacement items to match the "Year" of the original items.
For example:
Original ControlNo: 123456, Type Code: 0221, Year: 12
Replacement ControlNo: 123456F, Type Code: 1501, Year: 14
I would need to match the replacement ControlNo year to match the original ControlNo year. Hopefully this makes sense. Any help is appreciated!
I'm sort of new to creating Access queries and would like to see if I can get some help. I would like to know if it's possible to create a query to pull similar data sets from the same table or do I need to create a secondary query first. Below is my problem:
The main table is called "tblSample". Within the table, there's 3 columns I want to pull the data from and it's called "TypeCode", "ControlNo", and "Year". Within "TypeCode" column, there's a large set of key codes, but I mainly need to find all codes that are "1501" or "1502" which stands for replacements (this part I got). "ControlNo" column shows the original item number (ex: 123456). If there's an item that got replaced, a new entry should've been created, but an "I" or "F" was added to the end of the Control No (ex: 123456F) and the type code would be "1501" or "1502".
I need help on how to create a query where I can pull all replacement item "ControlNo" and also show the original item "ControlNo" associated with it because I need to make edits to the "Year" column of the replacement items to match the "Year" of the original items.
For example:
Original ControlNo: 123456, Type Code: 0221, Year: 12
Replacement ControlNo: 123456F, Type Code: 1501, Year: 14
I would need to match the replacement ControlNo year to match the original ControlNo year. Hopefully this makes sense. Any help is appreciated!