473,322 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Displaying Records from query

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
1 1160
NeoPa
32,556 Expert Mod 16PB
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

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

Similar topics

6
by: Matt K. | last post by:
Hi there, I have a form in an Access project that contains a subform which displays the results of a query of the style "select * from where = #a certain date#". In the main part of the form...
5
by: Robert | last post by:
Hello Accessors I have some reports created in Access that are very good for what they do. However, it seems to me that when you are displaying information you don't need to print out that a...
3
by: Chanchito | last post by:
hi there, I am seeking some guidance in regards to creating a query. I would like to be able to have the query display records that have had a certain amount of time pass since the time that is...
5
by: tdmailbox | last post by:
I have a form with a child form. In the child form there is a list of names that can grow quite large. On the parent form I want to display the first name from the child form. I set up a test...
9
by: MLH | last post by:
I have a database (datatrek.mdb) with a table named DATA. The table has a date/time field with default value = Now(). It has 100 records in it entered over a 50-minute period. I would like the...
9
by: Susan Bricker | last post by:
Greetings. I am having trouble populating text data that represents data in my table. Here's the setup: There is a People Table (name, address, phone, ...) peopleID = autonumber key There...
2
by: VM | last post by:
When I display data to a Windows datagrid I usually fill the underlying table (in another class) and then, once it contains all the data, I attach it to the grid. But there are some processes that...
3
by: Richard Carpenter | last post by:
I understand how to use a dropdown list control to display the associated description value for a foreign key in a parent rather than the key itself, but I don't like having to disable the control...
3
by: Col | last post by:
Hi - I'm using Access 2000. I have a combo box with 4 columns based on a query with 4 columns. The query has 111 records. The combo box will only display 11. When I had 3 columns, it displayed all...
5
by: sejal17 | last post by:
hello everyone, I have a problem with displaying records between two dates.Below is my designing page: start date: combobox of month(smonth) & combobox of year(syear) end date :...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.