Search results

  1. G

    Maximum date query

    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...
  2. G

    Using Count function

    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...
  3. G

    Need help with query!

    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...
Back
Top Bottom