Search results

  1. J

    Generating records

    Hi, My questions is how to generate records to a new table. My input is an inventory table. I want to generate a record for each item in stock. For example, ItemA has 4 items in stock, ItemB has 13. I want to generate a new table with 4 records for ItemA and 13 for ItemB. This table will...
  2. J

    Counting entries in a query

    I want to display the Student_ID, Section_ID and Enroll_Date from the Enrollment table for the first 10 students to have enrolled in February 2003 (there were actually 25 students that enrolled during 2/2003). I can select the students that enrolled in 2/2003 but the grouping does not allow me...
Back
Top Bottom