Recent content by rarejoep

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?