Search results

  1. A

    Finding dates before a certain date but the formula changaes each year

    I just altered and update qeury so that it's a wuery based on a table and a qeury but when i run it is comes up with Operation Must Use An Updateable Query This is the SQL Code: UPDATE tblStudent INNER JOIN [qry=3ForCrossTableQuery] ON tblStudent.[Student ID] =...
  2. A

    Operation Must Use An Updateable Query

    I just altered and update qeury so that it's a wuery based on a table and a qeury but when i run it is comes up with Operation Must Use An Updateable Query This is the SQL Code: UPDATE tblStudent INNER JOIN [qry=3ForCrossTableQuery] ON tblStudent.[Student ID] =...
  3. A

    Finding dates before a certain date but the formula changaes each year

    A huge problem has arisen that will massively disrupt the progress i make I need to add new units for the courses via a form, with the unit being uniquely identified using a Unit Code The Unit Code consists of the first 3 letters of the Subject Code, the first 2 letters of the Description of...
  4. A

    Using The Like function with data from a form

    Hello I have a ICT exam on databases in January for A2 ICT. It is based on a sixth form college I need to add new units for the courses via a form, with the unit being uniquely identified using a Unit Code The Unit Code consists of the first 3 letters of the Subject Code, the first 2 letters...
  5. A

    Using The Like function with data from a form

    Hello I have a ICT exam on databases in January for A2 ICT. It is based on a sixth form college I need to add new units for the courses via a form, with the unit being uniquely identified using a Unit Code The Unit Code consists of the first 3 letters of the Subject Code, the first 2 letters...
  6. A

    Finding dates before a certain date but the formula changaes each year

    What would it be like could you give me a example based on the one I already have?
  7. A

    Finding dates before a certain date but the formula changaes each year

    I've done it thankyou i used <DateSerial(Year(Date())-IIf(Month(Date())<9,1,0),9,1) can i ask you one last question? I need to validate a date field so that the date entered is in the current academic year from 1st setember to the 31st July how would you do this so that the year on the date...
  8. A

    Finding dates before a certain date but the formula changaes each year

    it doesn't work i just plugged it in Year(Date()) - IIf(Month(Date()) < 9, 1, 0) So you're saying the year of the date-what
  9. A

    Finding dates before a certain date but the formula changaes each year

    Can i ask what this does?
  10. A

    Question Date function problem

    Hello I have a ICT exam on databases in January for A2 ICT. It is based on a sixth form college In the scenario which we are given, they have informed us that we will need to "Automatically flag up students who have completed the first year" I'm searching for a formula that will look for...
  11. A

    Finding dates before a certain date but the formula changaes each year

    Hello I have a ICT exam on databases in January for A2 ICT. It is based on a sixth form college In the scenario which we are given, they have informed us that we will need to "Automatically flag up students who have completed the first year" I'm searching for a formula that will look for...
Top Bottom