[MS_AccessPros] Re: Q on filtering Access output

 

I tried to post this by email but it didn't show up.  Apologies if it duplicates.

Hi Gary

A query like this should do the trick – substitute your own table and field names:

SELECT Patients.patID, Patients.patFirstName, Patients.patLastName, ...
FROM Patients
WHERE Patients.patID In (SELECT vstPatient FROM Visits GROUP BY vstPatient HAVING Count(*)>1);

Warmly,
Graham

---In MS_Access_Professionals@yahoogroups.com, <gary.schwartz@...> wrote :

Hi:

I am using Access 2003 (system requirement for this database and
system it supports..

Pulling a large amount of data, both rows and columns, and would like
to simplify/speed up. Over 50 columns and 100,000 rows.

I need to exclude all patients who were in once, and only include
those with multiple visits.

Any thoughts? This would be possible in some versions of SQL, is it
possible with Access SQL? Anything possible with Access 2010?

Thanks,
Gary


--------------------------------------------------------
Gary D. Schwartz Please reply to: gary.schwartz@...

 

__._,_.___

---

Posted by: graham@mandeno.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___