I want to calculate like follows. From Datefield I want to find min and use DateDiff to count the number of days until Today. Then multipli it all with 92

Any one who can show me how to make the querie

Thanks in advance

What do you mean when you say you "....want to find min...'? What is "min"?

Sorry, I mean minimum, the lowest value

Anders

SELECT 92*DateDiff("d",Min(yourTable.[DateField]),Date())
FROM yourTable;

RV