I am going to reply quickly so that hopefully I will get your reply back this morning. I understand the spacing and the brackets. I learned that from you first and second post, I just haven’t changed it yet. It works somewhat and I was waiting until I understood everything before I changed everything.
The RequiredTest is the field with the information that I am trying to join to one student.
To go through the fields, the field...
Promise007
Last Activity: Oct 21 '16, 10:51 AM
Joined: Oct 10 '16
Location:
-
I did read the material on database normalization and I understand that.
I have tried to find some information on the Join table. I found some information on this page:
https://support.office.com/en-us/art...rs=en-US&ad=US
Now I am fuzzy on which field names to use to create the combined unique keys for the table that you missed in your previous...Leave a comment:
-
Hopefully, it won't make any difference, but the student information system provides me with a text file that list the OGT test that each student has to take. The list is a alphabetical list where is student has multiple records in the list, depending on how many tests each individual student has to take. I need an alphabetical list where each student has a single record and the test that the student has to take is represented by it's own individual...Leave a comment:
-
I am following you and my set up matches what you have said. I have a student table that list every student in the building and I have a test table that list every test that has to be taken by every student. Each test is a separate record. The primary key for the student table is the Student ID number and this number is the foreign key in the test table. That is as far as things go. I think from the reading, I need to set up a one to many relationship...Leave a comment:
-
This has been a long process. This is the final step in a process that started with concatenating multiple records into a single record. Each person or student has to take one or more test (up to 5 tests). Each value was originally listed as a separate record, so if a student had to take all five tests, he or she would have five records represent them. I was able to concatenate the data so that each student has a single record and all of their...Leave a comment:
-
If Then Statement Looking at a Field with Multiple Values
I have a query that has a calculated field with multiple values.
The values are 10R, 10W, 10S, 10C, and 10M. The field may generate an answer as any one of these values or any combination of these values. For example one person may have this as the result: 10R,10S
Another may be: 10W, 10C (The field is one or multiple values separated by commas.
I am wondering is there a function that looks at just part... -
I was able to finally figure out the various issues I was having. I did get things working for a second on Friday, but then I got an error message saying that there was an undefined function in the expression. I finally found that the module and the function have to have different names. Then I got another error message saying that there was an ambiguous in the expression. The problem was that I had two modules with different names, but the same...Leave a comment:
-
I think I found the problem. I located a post on the following website:
http://datapigtechnologies.com/blog/...ons-in-access/
The person was responding to someone else who had a similar problem. The issue is making the mistake of naming the module the same as the function. I am attempting to correct this error.
Thanks....Leave a comment:
-
I followed the suggestions that you both provided. I did get exactly what I was looking for. I used the following expression: Which_Tests: ConcatRelated("[OGT Test]","[Copy Of Copy Of WhoNeedsOGT]","[State Student ID] = """ & [StateStudentId] & """")
But when I went to close everything down and open it back up again, I got the following error message:
"Undefined...Leave a comment:
-
How to move multiple records about same person to one longer record?
I am trying to give a the OGT test to several of the school's students. There are five possible tests that a student may need to take. Some only needs one, and so on. The information that I am getting from the student information system displays the information about each student in one to five rows or records, depending on the number of tests the student has to take. The student's name and ID number are repeated in each row, but the name of... -
Phil,
I tinkered with it and now it works, but I don't see any difference from what we were using a minute ago. This is the expression that works:
Testing Completed: IIf(IsNull([NoMath]![NoMathTest]) And IsNull([NoReading]![NoReadingTest]),"Yes","No")
Thanks much!Leave a comment:
-
Phil,
Unfortunately, it is still not letting me sort. It does what it it supposed to do, putting Yes in the column for those who have completed both tests and No otherwise, but when I go to sort by Yes and No, I get an error.
I appreciate your advice on the spaces, I did not realize that putting a space in the field name would require brackets. I will go back and rename the fields without the spaces and go from there....Leave a comment:
-
Everything is almost complete. I still have one error that will not allow me to sort by the Yes or No. When I try to sort it displays the following error message:
Syntax error (missing operator) in query expression 'Testing Completed'.
What am I missing? Thanks.Leave a comment:
-
PhilOfWalton,
I added the double quotes as you suggested and I got an error message that said I had a syntax error. I changed it to single quotes and I got all No's.
Then I copied and pasted what you had in your message and it worked like a charm. You are a genius! Thank you very much for your help.Leave a comment:
-
I have learned a few things since the initial post. First, I was trying to put the expression down in the criteria section of field from one of the tables. I have moved the expression to the Field name of a blank column in the Query itself. I played around with it and I got it to work somewhat. This is my expression at this point:
Testing Completed: IIf(IsNull([No Math]![No Math Test] And IsNull([No Reading]![No Reading Test])),Yes,No)...Leave a comment:
-
Writing an IIF Access statement with an embedded IsNull statement
I am in the process of trying to build an expression in Access 2016. I have three tables that are joined by a common field in a query. The first table is called No Math and it has a field named No Math Test. There is also a table called No Reading with a field named No Reading Test. The third table is called No MAP Test and has a field named Completed. I am a teacher and I am trying to create a way to keep track of who has taken the Math and...
No activity results to display
Leave a comment: