Recent content by sarah23

Just an update, I figured it out. I used the instructions from a thread on Ozgrid Excel Help & Best Practices Forums and a page from Microsoft Office support to make two crosstab queries - one for students, and one for student numbers. Then I made another query to view both crosstab queries at...

I know, there is no actual personal data in the relationships window. But because the group I'm working for has very tight confidentiality rules, I'm just not comfortable with posting any aspect of my database online. (Even the names of the tables and fields are pseudonyms). I know it sounds...

I am not able to post a screenshot of the relationships window due to privacy issues. The original database's relationships window had the New Teacher Registration table, which included: - id - Teacher Name - Street Address - Email - (and other information about the teachers) - St1 - St2 - St3...

Thanks again for staying with me here, jdraw. The database that was given to me had these things: 1) New Teacher Registration Form that fed into 2) New Teacher Registration Table it also had 3) Detention forms The form had text boxes to put the student info (name and number), which linked to...

Thanks for responding to my post, jdraw. I understand that this may not be the most ideal circumstance to keep my database normalized. Unfortunately, this is an old database, and I've been asked to "clean it up." So I don't have the authority to revamp the whole thing from scratch. My...

Hi there, I'm new to Access and know pretty much nothing about coding. I have a table ("Student Info") that looks like this: ID....Student.....Student #......Teacher Name......Teacher ID 1........A...............432...............Alice...................62...