I don't quite understand the concept. Maybe you could clarify by describing
the desire result using Assembler, Java, BASIC, C, or some other non-Access
platform.
Ask questions regarding Access in terms of Acess, not one of the above.
Use a query on your table. If the concept of queries is new to you, look in
Access Help. You might also get one of the more basic books such as Access
[yourversion] Step by Step from MS Press.