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

Thanks, it works. Is it a lot of work to make it work also with months and days?

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

Is it also possible to use some code that shows an A if it's a 1, and a B if it's a 2??

Is it also possible to include some kind of If-Then query, that selects the highest result and makes that one Bold? Because it's not sorting and both results are shown.

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?

That's what I do: I select the GroupName, that is A or B. But in the report I see 1 or 2...

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?

Yes, but I think I solved it. I made the field size Decimal and set the the Scale to 2.

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

It doesn't work if you put it in the Control Source. It must be in a query?

I've put in the Control Source: =[date]<=Date() where date is the list of dates in the collumn but it results in an error...

Thanks

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

So it is possible with some kind of function? Can you tell me which one?

I've got a table of Trainees and a table that keeps track of who was absent during a course. Only the absense, because then you automatically know the attendance I think. The information of the courses comes from MS Project, and through a referencenumber I can fill in the absense of a trainee...