Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating a DB with friendly forms
Thanks for the suggestion, Spyder. While that would reduce the effort required for the user to input the data for each assignment, it's still more effort than the user (my wife) is used to doing in Excel. Instead, I've come up with an unconventional solution. I have created one table with...- caerulea
- Post #5
- Forum: Microsoft: Access Forms
-
Creating a DB with friendly forms
Hi Chubby, Thank you for responding! I appreciate you trying to help me out. Unfortunately, I think I don't get it. When I build a form based on a query that links the 3 tables, for each assignment, the user still needs to re-enter each student name before assigning a score. I don't think I...- caerulea
- Post #3
- Forum: Microsoft: Access Forms
-
Creating a DB with friendly forms
My wife is a school teacher, and I am trying to help her by creating a database that can track student performance and calculate grades. The basic structure has 3 tables: Students (e.g., [StudentID], [Name], etc.) Assignments (e.g., [AssignmentID], [Subject], [Discipline], [Date], etc.)...- caerulea
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Top ten on a group by query
Mugs: Did you ever figure out the solution? I'm trying to do the same thing with my data, and I can't figure it out. Cheers!- caerulea
- Post #5
- Forum: Microsoft: Access Other topics
-
Using the Top predicate with Group By?
I would like to select the bottom 5 values for different types of data. Is it possible to use the Top predicate with aggregated data? Or is there another solution? Thanks!- caerulea
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
