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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. caerulea

    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...
  2. caerulea

    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...
  3. caerulea

    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.)...
  4. caerulea

    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!
  5. caerulea

    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!

Part and Inventory Search

Back
Top