Recent content by ppines

When I make this amendment I receive the following message: "Syntax error in FROM Clause."

I have used Excel to clean the data (using 'advanced filter' and 'remove duplicates'), redesigned the database based on the start schema suggestion, and created a new query. At least this SQL runs! However, there is no data, so I could use some help with redesigning the query and/or schema...

Thank you! I will use this to create the new database.

See attached example, same line item repeated for the Student in the original Excel file.

I was asked to use MS Access by the Math faculty to clean the data and create the query. I don't know SASS or SPCC. UNSW_Maths table has duplicates - it lists the student number, all course codes (but we are focusing on Math1131 only) and the course description. We are only focusing on this...

The original Excel file was 277MB - 72 columns 912902 rows - and is riddled with duplicate records. I originally uploaded this file into Access and could not create the needed tables. I broke it into the required separate tables in Excel to load it into MS Access using Student as the...

There are 913,300 records. I want to find all the duplicates and delete them first, then complete the TRANSFORM. If I remove the GROUP BY statement will it work? DELETE FROM Numeracy_UAC WHERE ID NOT IN ( SELECT MIN(ID) FROM Numeracy_UAC; If not, how could I amend the code to remove...

I used Crosstab which requires Group By. I am not sure how else to go about it.

The query runs; however, it’s a big database and tends to hang: Design Code TRANSFORM Count(Numeracy_UAC.UAC_QUAL_SUBJECTS) AS CountOfUAC_QUAL_SUBJECTS SELECT Numeracy_Enrolled.ACADEMIC_YEAR, Numeracy_Enrolled.ENROLLED_TERM FROM (((((((Numeracy_Student INNER JOIN Numeracy_Enrolled ON...

Thanks for all your help. It finally worked!

Thank you. If I rename StudentID to Student and create a new StudentID as per the others, this query should produce results. I will amend the table and try again.

I am new to MS Access and used the Query Wizard to design my query. However, it is producing no results. What am I missing? SAMPLE DATA QUERY DESIGN SQL RESULTS

Hello, I am new to Microsoft Access and keen to learn as I have recently been thrown into the deep end of my job. I am from Australia and looking forward to engaging with the community.