Query help!!!!

[NDBadger]

I have a basic table that holds all of my shops student records. These records include 22 different classes listed as individual field headings. Under each of the class names is the date each individual completed the course of study. As some of these are recurring training I am trying to build a query that will search through the entire table and list out the dates that are between 10 months ago and earlier and only show those dates. I have gotten a query to show all students who have at least 1 class comming due however it shows the entire record.

Basically I want the query to give me students name, class due, and date completed. Am I asking to much? Do I need to recreate the table under a different format?

 

[ctr1085]

What are the fields of your table? What's your table name?

Here's what I could think of from your question.

Query:

SELECT Student_Name, Class_Due, Date_Completed
FROM basic_table
WHERE Date_Completed <= DateSerial(Year(NOW),Month(NOW)-10,day(NOW))