Show Only Current Due Dates Per Team

[Shawn via AccessMonster.com]

I am working with a database that tracks when patients need their next
visit. Each visit must be 90 days from the last. I did this using a query
"NextVisit: [Current Visit]+90". That works. However, I need to see all
patients per team that are coming up to a visit. I also need to see the
most current visit prior to today for each patient per team. Hope that
makes sense. I set my tables up so that I have Patient information in one
table and Patient dates in another linked together by the PatientDateID. I
don't know if that is correct either.
Any help would be appreciated,
Shawn

 

[Rick B]

Well, you don't tell us what a TEAM is or how it can be pulled in the query.

You say you want to see only appointments coming up, but you don't tell us
what time frame. All of the patients have a visit due sometime in the next
90 days. Do just want to see those due in the next 30 days? 7 days? What?