By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Query Problem - Help!

trueadvantage
P: 12
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
Feb 6 '08 #1
Share this Question
Share on Google+
3 Replies


rsmccli
P: 52
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
Feb 6 '08 #2

pod
100+
P: 298
pod
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

Expand|Select|Wrap|Line Numbers
  1. SELECT stu.id, stu.first, stu.last, mks .marks
  2. FROM tblinfo AS stu
  3. INNER JOIN tblmarks AS mks 
  4. ON stu.id = mks.id
I hope that helps

P :oD
Feb 6 '08 #3

NeoPa
Expert Mod 15k+
P: 31,186
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.
Feb 6 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.