Search results

  1. 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] =...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
Back
Top Bottom