MS ACCESS DB help

Guest User

15y2.2k

I have a c# program with a MS Access DB that holds various details about various things.

I have created a set of functions to build the sql requests / oledb requests for reading writing and counting e.t.c using RequestScalar, although now I have hit the limit of my knowledge of oledb and queries.

I have a table that contains a set of records each with a uniquie ID and other details including a category id. Each category ID can be used many times in this table for different records.

I have the category ID and I want to fetch all of the records that have this category ID.

Can anyone guide me in the right direction?

Thanks in advance
Adam

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Using SQL Joins, search for articles here. So that you can learn instead of we answering it.
Guest User15y ago
I have put some example data below

YearGroups
YearID Name
1 Year 7
2 Year 8
3 Year 9
4 Year 10

Students
ID FirstName SecondName YearID
1 Billy James 1
2 Rob Smith 2
3 Jane Thomas 3
5 Lilly Pike 3
7 Bob Williams 3
8 Mitchel Sanders 4
9 George Smith 4

An example of what I want to do is....

I have the YearID "3" and I want to get a list of the first and second names of the students that are in that year.
Suthish Nair15y ago
can you provide the table structure. If using different tables, use sql joins.

ID	FirstName	SecondName	YearID
1	Billy	James	1
2	Rob	Smith	2
3	Jane	Thomas	3
5	Lilly	Pike	3
7	Bob	Williams	3
8	Mitchel	Sanders	4
9	George	Smith	4

YearID	Name
1	Year 7
2	Year 8
3	Year 9
4	Year 10