Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-17-2017, 11:25 AM   #1
jlavin
Newly Registered User
 
Join Date: Jul 2017
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
jlavin is on a distinguished road
Cool Multiple records question

I am looking at a table that could have the same person on it more than once. A visit table. I have a unique ID and DOB on this table.

We have had some data entry issues and I would like to look at this moving forward as well, so what I am trying to do is list all the people and all their records that have DOBs that are not all the same.

For example - the filter should show both Person A records from below.

Name DOB

Person A 1/1/1950
Person B 2/2/1960
Person C 3/5/1999
Person A 1/2/1950

I hope this makes sense. I really appreciate any help. I tried searching for this but didn't find any "multiple record" posts where having multiple records was a good thing.

jlavin is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vba inserting multiple records from multiple unbound text boxes jackie77 Modules & VBA 5 05-08-2014 02:16 AM
Question: Counting records in multiple tables in one querry Top Fuel Friday Queries 1 09-23-2010 10:42 AM
Question [Urgent] Filtering and saving multiple records in multiple columns. sx1 General 9 06-03-2009 12:37 AM
How to show multiple records on form only if multiple records exist? duckster Reports 5 09-21-2005 08:05 PM
Question on Saving in multiple records jazzscreamer General 4 03-27-2004 01:04 PM




All times are GMT -8. The time now is 06:31 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World