Search results

Thanks Thanks. problem solved! ur a hero.

The DemoUpdateQryA2000.mdb works fine until the year group 9B changes to 10 because it doesn't add the letter B. Try updating it 2 times and check the table because the Tutor group doesn't include the letter the any more. if you could sort this problem then the problem would be solved! hope u...

i am trying to update a field within a table. But i dont want to update the whole of the data within the field just one part of it. The field is the Tutor Group for students in the format 7B, 7D, 7F, 7H, 7M, 7S, 8B, 8D, 8F,... etc where the number represents the year group! i want to use an...