Query Problem - Help!

**rsmccli** · Feb 6 '08, 12:59 PM

Pick "New Query"
Use the wizard or just pick your table from the list in Design View.
Pick your two fields (Student Name, Marks)
In Design View, in the Marks Column, type this in the Criteria field:

Like "Mark1"

(replace Mark1 with whatever value you want to filter by)

If you want to show students that got Mark1 or Mark2, then type this:

Like "Mark1" Or Like "Mark2"

rsmccli

**pod** · Feb 6 '08, 01:08 PM

Originally posted by trueadvantage

Hi,

I am having a slight but not critical problem.

I am beginer with the MS Access and still learning.

Problem...

I have 1 datasheet which includes two rows, first is Student name and second one Marks. in the sheet some of students has got same marks.

I want to build a query which will help me to find out their names who has got same marks. (means If i puts marks in marks field so it should disply those students name who got same marks.)

I tried a lot but as i told u im not famileer wid access at all.

Can anybody suggest me...? need help

Thanks

mmm.... I am not certain what your design looks like... but I think you should have one table for student information with the following fields; student ID, first name, last name, ... and one table for student marks with the following fields; ID, marks then you could do a query

Code:

SELECT stu.id, stu.first, stu.last, mks .marks
FROM tblinfo AS stu
INNER JOIN tblmarks AS mks 
ON stu.id = mks.id

I hope that helps

P :oD

**NeoPa** · Feb 6 '08, 03:24 PM

Originally posted by NeoPa

Please visit this thread to see why we would rather you didn't double-post (Please do Not Double Post).

You have posted this question twice, thus wasting the time of some of our members.

The other thread is located at Simple SQL Problem.

Query Problem - Help!

Query Problem - Help!

Comment

Comment

Comment