Search results

wonderful! Cheers

Kiwiman - thanks for the quick reply! I have found the index tool, and this is going to sound thick as I've probably missed something obvious, but how do I select 2 fields for the index? It only lets me pick one from the combo box. I'm using Access 2007. Cheers

Hi, I am creating a database for a school. I have each child's details in a table called 'tblChild', and each child's grade in a table called 'tblGrade'. As I am trying to track the child's progress through the school, the grade table contains a year column. As the database is updated each...

Any other ideas from anyone?

wonderful. cheers guys

This seems to be a fairly simple thing to do, but I can't for the life of me get it to work! I have an option group containing 5 options - Reading, writing, numeracy, science, speaking and listening. Based on the choice made by the user, I'd like to open one of 5 different forms - fReading...

Will that not just filter out the data in the table on the basis of the query? Will that save the result of the equation in the PointsProgress field?

Hi, I've read everywhere while searching for solutions that the Golden rule of access is to calculate anything which can be calculated rather that storing it. However, for various reasons the data does need to be stored. So here's what I'm after. The database is for a primary school, and...

Awesome. Cheers!

Hi, I've been having a butchers, but couldn't find any solution to my problem - apologies if I've missed an answer somewhere - please link me! My database is sorted and I'm looking to make it more attractive. I know it's only superficial, but the buttons on access look really boring. I'd...

Genius! I knew it would be something painfully simple. Cheers!

Hi all, This is my first post, so please bear with me if I forget something out which you need to help me! I'm creating a database for my school to monitor pupils progress. All of the information I need for this problem is in one table. I want to be able to show overviews of children...