RE: [MS_AccessPros] Q on filtering Access output

 

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

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, 23 May 2018 11:56
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Q on filtering Access output

 

 

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@pobox.com

__._,_.___

---

Posted by: "Graham Mandeno" <graham@mandeno.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

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

.

__,_._,___