Criteria Problem Question

[accesser]

I have a very important question. It is logically easy but the problem is how to write the criteria. it is as follow:

I have table "EmpCardholders". It consists of the fields:

-Name as text
-CardNo as text
-JoiningDate as date/time

None of its fields is indexed (distinct). it could be repeated.
I have the variablea
-"Etime" as date.
-CNO as string

What I want is to find the maximum DMax value of the "JoiningDate" field where this value is datediff("s",joiningdate,Etime)>=0 and "CardNo"=CNO.
Please Help Me.

Thanks

 

[pdx_man]

You may have to create two queries. The first with your criteria, then create another query based on this query where you use the MAX. Or you could just do the DMAX against the initial query.