Recent content by Aaron Greatbanks

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] =...

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] =...

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

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

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

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

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

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

Can i ask what this does?

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

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