Recent content by mstoller

I added a new table called Dates, that table has 4 columns, ID, Year, Term, Startdate. I added a relationship between the Year and Term columns on my two tables, (All and Dates). Now I believe it should be easier to exclude the older entries in my query but I still can not figure out how to do...

I used two queries to do this, SQL below, first is to pull 13 Q out of the single table, and the second is to compare it to the single table, First: SELECT [All].* FROM [All] WHERE ((([All].Title)="NO INFORMATION RECEIVED") AND (([All].Year)="13") AND (([All].Term)="Q")); Second: SELECT...

I was able to recreate what I had done earlier (but now with the normalization you had me do), so I have a query that is working. It lists what books were previously used for the classes being taught in the upcoming Fall semester. The query has the following headers, ID, Year, Term, Department...

I'm not sure how to set up the query even with the one large table. Apologies again for being such a novice. An example of what I am looking for, if (Department)AAR(Course)1500(Section)45(Instructor)Taub is in 13Q with a textbook title of No Information Received (Every one is at this point if...

The old spreadsheets (from semesters that have happened already) show what books professors used previously in those courses. The new spreadsheets (for the upcoming Spring and Fall) show the courses being taught. This is what I combined into one table. I would like to see what books were...

Ok, apologies for not understanding that, I have now created one table called All. I have also separated the term field into two fields as suggested, Year (10, 11, 12, 13) and Term (A, J, Q, W).

Bob, Thanks for taking the time to help me out, I combined all of the old semester tables into one called History. Table 13J and 13Q are still there since they are the ones we to compare with History. Fields remain the same, Term, Department, Course, Section, Instructor, Title, Author...

This is my second attempt at designing a database so I'm very new to the process, was hoping someone on here can help me out. I have found plenty of great information here that got me to where I am, but now I could use some help. I am working on an Access database for a College Bookstore. The...