Terry-
SELECT [119-1Block], [119-1Date]
FROM MyTable
GROUP BY [119-1Block], [119-1Date]
HAVING COUNT(*) > 1
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
Sent: Tuesday, November 01, 2011 9:46 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] SQL Syntax Help Needed - Find Dup columns in a table
I can¡¦t seem to find the right SQL syntax to find 119-1Blocks that have the
same 119-1Date. My table, DateTrip, has two columns, 119-1Block, and 119-1Date.
There is a set of dates associated with each block. Each 119-1Block with more
than one date will have more than one row. Our business rule is that there can
be no 119-1 Blocks with the same 119-1Date. This is an example of the data.
119-1Block,119-1Date
71701,10/1/11
71701,10/2/11
71701,10/3/11
71701,10/2/11 „² looking for this occurrence, duplicate of record 2 above
71801,10/1/11
71801,10/2/11
71801,10/3/11
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar