Recent content by KiwiPhD

vbaInet - I would appreciate more communication with you - share my work with you - this system is Excel/Outlook based - generates unique multiple choice and Excel (accounting - pivot tables, array algebra, etc) for students - no two students receive the same assignment. All data stored in...

Thank you vbaInet. Excellent, greatly appreciated - I shall study why it works and learn form your wonderful effort.

vbaInet - Go here and clink on accdb link http://www.bus.ucf.edu/faculty/pgoldwater/page/Links.aspx

vbaInet - trying again www.bus.ucf.edu/faculty/pgoldwater/file.axd?file=2014%2f8%2fAssignmentSystem.accdb

vbaInet - this service automatically abbreviated my link. Consequently the link is not valid.

http://www.bus.ucf.edu/faculty/pgoldwater/file.axd?file=2014%2f8%2fAssignmentSystem.accdb Access - has relevant two tables and two queries. Thanks vbaInet

Will post link to "reduced" Access database.

The Access db is live - 200 students interacting with it 24/7 The SQL of this thread is for an elaborate report I am creating.

Query1 SQL SELECT StudentHeader.[Student ID], StudentHeader.GUID FROM Student INNER JOIN (Assignment INNER JOIN StudentHeader ON Assignment.GUID = StudentHeader.[Assignment GUID]) ON Student.[Student ID] = StudentHeader.[Student ID] WHERE (((Assignment.[Assignment Type])="Q") AND...

Thanks vbaInet - this works - location of GROUP BY SELECT Query1.[Student ID], Query1.GUID, (SELECT Count(*) FROM Query1 AS A WHERE A.[Student ID] = Query1.[Student ID] AND A.GUID <= Query1.GUID) AS Sequence FROM Query1 GROUP BY Query1.[Student ID]...

Thanks vbaInet SELECT Query1.[Student ID], Query1.GUID, (SELECT Count(*) FROM Query1 AS A WHERE A.[Student ID] = Query1.[Student ID] AND A.GUID <= Query1.GUID) AS Sequence FROM Query1 Gives error "Invalid argument to function"

Thanks vbaInet - I did that (see above) and got new error message "Invalid argument to function"

I tried to post a link to a jpg - but I do not have the requisite 10 post, yet.

I believe I followed the 4 steps correctly. I receive error message "You tried to execute query ... does not include A.GUID as part of an aggregate function". SELECT Query1.[Student ID], Query1.GUID, (SELECT Count(*) FROM Query1 AS A WHERE A.[Student ID] =...

Thank you for helping. Some students took one quiz and other students took two quizzes. You can see the instances of the student ID. So, students may take the quiz once, twice, three times, etc