Recent content by GIDATS4978

I appreciate all of your help. I'm restructuring my tables. Here is what I have so far. CompetencyTable Comp_ID Comp_Name (Only 2 -- "Foundational" & "Functional") PrimarySubjectTable Prim_ID Comp_ID (from CompetencyTable...The first 3 Prim_Name fall under "Foundational" and the last 3...

The numerated fields names are the abbreviations for the "subjects" they are graded on. I felt that instead of typing out the entire name of each "subject" I would use the number. For example 1A is "Integrity", 1D is "Concern for the Welfare of Others" and then 1A thru 1E is under the overall...

Sorry, I was working on another project yesterday. Here is my database. I zipped it so it would be able to be attached. Thanks for the help.

Here's a jpg of the relationships I have with tables and queries. Let me know if you need any other information.

I pulled all of the data into one table from an existing Excel spreadsheet. My supervisor now wants an Access database which I've been working on. I have designed it so far where every student has a main form page with subforms to other information (demographic page, admission information...

I'm not sure how I would go about restructuring the table. The table that this query pulls from right now has all of the student's grades for each of the "subjects" which will be the 1-5 score and the 99 as "Not-Observed". I already have a table with all of the student's demographic...

I am trying to return all values or both Null and 99 as 0's and then average the 5 fields in the query by the number of fields that have data greater than 0. My original expression...

My supervisor has tasked me adding a radar/spider chart to a database but I'm unsure how to do this. I found the Microsoft Graph Chart in the Unbound Object Frame. Is this where the radar chart is found? The radar chart will be filtered ID on the form and he wants the chart to display that...

Thanks. That would work, however I'm trying to track grades. The teacher can put a number, "N/O" as "Non-Observed" or some have left Nulls (meaning they just didn't put in the grades yet). I would like to get the average of the grades but leave out the "N/O"'s and the Nulls. That's why I was...

I tried searching the forums for this but can't seem to find it. I have a table that has data as a text field. The data will be Numeric, Null or "N/O" as being "Non-Observed". My query expression works if the data type is numeric (without the "N/O"'s). However, I can't seem to figure out how...