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

Displaying Records from query

P: 13
I want to create a report for evaluation purposes, the report will display.
Name: Jhon
ID: 104
Discharge Reason: Drop Out
Discharge Date: 12/05/06
Assignment: Drafting

My problem is creating a query. I want show only students who entered in to their trade directly only once. So I don't want any student who took a remedial class, regadless of what trade they are in or what classes they took if they took a remedial class they should be out the list.

So for instance:

Name Assignment
John Reading Clinic (remedial) don't want him
John Drafting don't want him same guy as above
John Drafting 101 don't want him same guy as above
Mike Drafting I keep this one
Micke Drafting 101 I keep this one but same guy as above but only count him only once
Tom Reading Clinic (remedial) don't want him
Tom Auto Mechanic do't want him same guy as above
Paul Auto Mechanic I keep this one
Paul Auto Mechanic 102 I keep this one same guy as above but want to count him only once
So what is the best way to eliminate the duplicate trailing names to display only once so I can do some couts and evaluation.

Thank you in advance for any assistance
Dec 8 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,661
I'm a bit confused as your explanation is in a different format from what you show above (nice and clearly explained though).
Can you show how the data is stored (so what we have access to)?
Perhaps that matches your explanation more closely.
Metadata (table name followed by a line for each field including name; type; index info; ) would make it a lot easier to work with if you could provide that.
Dec 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.