Search results

On a report I made, you see attendance rates of classes. If they are below 95%, I would like Access to make them automatically red. Does anyone know how I can do that???

I am making a database of trainees. Every trainee has an id-number, that starts with the last 2 numbers of the year of birth. I want on the form a textbox or label that can show the age of that person. So it must calculate the year we are in right now minus the year of birth. Does anyone know...

I've got a report that shows all the (school)classes that are given in the first collumn, the amount of students that were absent in the second and in the third collumn the group a student is in. In the last collumn I would like to have an attendance rate. That must look like this...

From a query, I get results of tests. There are 2 results per test, and I would like to get the highest of the 2 results bold. Does anyone know how I can do that?

I've made a report which shows results of trainees sorted by Group they're in. The groups are called A and B. In tables and queries they look like A and B, but in the report they are called 1 & 2, and this is nog what I want. Does anyone know how I should change this?

I want to save results of tests as numbers with 2 decimals. I've searched but I can't find out how to do this (without using input masks).

I have 2 text boxes, both with a result of a test. The highest score counts, and that one I would like to show in an other textbox. Does anyone know how to do that?

On a report, I want Access to show me all the records till the day today. Does anyone know how I should do that?

I want a query to select only the items till this date. I think I must put this in the criteria cell, but I don't know how it sees the date of today, something with "currentDate"? Does anyone know?

I am making a database that contains trainees and courses. It must be able to record the attendance of every day a course is given. I was thinking of a list of courses and dates, and with every combination you can give up which trainees where absent. This works. Now I want to have the...

I am making a database that contains trainees and courses. It must be able to record the attendance of every day a course is given. I was thinking of a list of courses and dates, and with every combination you can give up which trainees where absent. This works. Now I want to have the percentage...

Does anyone know if the borders around subforms can be hidden (and how)?

When the Form opens, it has to go automatically to the last row in a table. Is this possible?

I have managed to make a pulldown list with carID's where you can choose a car. Below this, a table is showed with elements concerning the car. When you change the car, the table also changes. But here's the problem: the elements from the list are updated when I enter new data in the tables...

Hello, this is maybe a simple question but I have to know. I am working on a database. One of the elements is some kind of personnel admin. I made a form with all kinds of details of the personnel, like names, surname, age etc. I would like to have a pull down menu on for example the surname...