Search results

Alan, That was so stupid of me, spelled the names 3 times wrong :/ In regard of changing records. Yes, that's exactly what I want. I'll try again to make clear what i'd like. I'd like to make an UPDATE query that changes the field "decision" and "decisionDate" in all records in the database...

Thank you jdraw, i will try to find the time to get through all that ;)

I'm feeling such a moron right now. But i don't seem to get this to be running as i want :). What kind of query do i need to make? I thought an update query, but then if i change the view to sql view and paste the above code: SELECT Students.[Name], Students.Surname, Students.adviseTeacher1...

Jdraw, Well actually i'm working on a database to have less workload, so its strictly personal, not commercial. I was figuring out a way to have less paperwork, etc and found a possible solution in access by way of a database. The problem is that it is quite new for me. I'm looking after some...

Alan, thank you for your help, i changed the name in fname ;). There's something i don't understand about this function though. If i understand it right then the function checks if the 3 advises are positive, if so then it returns positive as decision if not it changes it in stand-by? But what...

Hey everyone, access is totally new for me so... :) I have the following "Students" table With columns name, surname, adviseTeacher1, adviseTeacher2, adviseTeacher3, decision, decisionDate I would like to make a query that compares the advise of the 3 Teachers and if all of them are...