Recent content by species

I have result using IIf([VolgendeActie]=Date();[VolgendeActie];[LaatsteActie]) It returns the correct dates. Now I have to implement it in the form. This brings me to the same problem. If I donot recalculate the dates, they will be lost when the day is passed.

Just tried the query and it returns an error about using brackets for the arguments.

Many thanks Poppa, I will give it a try.

I'm still getting nowhere. Attached is a sample of my database. Maybe this explains my problem. In the form the dates will not update, causing error problems. As I have noted when the date() reaches VolgendeActie, this date must be transferred to LaatsteActie and calculate fields Herinnering and...

Date problem! The simplest way to explain my problem is that I have a table with a date named LaatsteActie. In a query I create two more dates. VolgendeActie (this is 1 year later then LaatsteActie) en Herinnering (one month minus VolgendeActie). Till here everything works like a charm. I put...