Hello every one, somtetimes ago I created a database in access in order to calculate the days of my life. In one field I put my birth date and in another one the date of today which is fullfilled automatically any time i get in the database. In the expresion builder I put the formula "date of today" - "date of birth" and I get the result total days lived. The problem is that now I want to use this database to calculate the days of the warranty for a certain product and when it reaches for exaple 365 days this field should come out in red or a certain colour "not black".
So please can anyone tell me how to do it because I really need to know it how many days ago I sold a certain article.