Trying to Query <= 90 days from their last visit (1 Viewer)

[kawai6rr]

I have this query where I'm trying to query everybody who's last visit was <= 90 days from todays date.

SELECT DISTINCT memberInfo.MRN, memberInfo.Last, visits.LastSeen
FROM memberInfo INNER JOIN visits ON memberInfo.MRN = visits.MRN
WHERE (((visits.LastSeen)<=Date()-90));

but this does not work, can anybody help?

thanks.

 

[boblarson]

Change this:
WHERE (((visits.LastSeen)<=Date()-90));

to this

WHERE visits.LastSeen Between DateAdd("d", -90, Date()) And Date();

 

[kawai6rr]

That worked great, thanks!!