Recent content by GaryJ

Hi I have 5 different fields that contain dates of different stages of a training process. What I need is query that returns the latest date accross 5 fields So I need a query that tells me the lastest date from the fields, stage 1, stage 2, stage 3 etc If stage 1contained 28,09,09, and...

Works perfectly - exactly what I wanted. Thank you so much!!!

Ok this is probably so simple, but I am relatively new to Access, so thats my excuse!! I have a table that has student funding trigger data in it. one field is there course funding trigger, either "enrolment" "Completion" or ""Achievement" All I want to do, is somewhere have a total of...

Brian, sorry to sound so dumb, but I hadnt used SQL view before, I have used your code, and the query has run, Im just gonna check now to see if it has pulled the results I wanted, but so far it is looking good. Thank you so much - you are a star!!

Thanks for the replys, and Brians does look simple, however I have never used SQL view, I always use design view. I know this is cheeky, but as the code seems quite small, could you create me the code that I could copy and paste into SQL view?

Hi This is probably really easy, however I cannot find a way to do it. OK, I have a table that contains student records. The first column is their name(changed to student 1, 2 etc..) the second column is the course thay have completed, and the 3rd column is whether they have passed an exam...