|
| |
|
|
Athema
Posts: 5
Joined: 2/11/2009
Status: offline
 |
Unique Records? - 2/11/2009 12:10:11
Hi there,
I hope someone can help or point me in the right direction...
I am using MS frontpage 2003 which is running an MS access database, in the database it has a row of duplicate data which I would like to be omited from the database results page and just output the unique records.
I have looked everywhere to try to figure this out as I thought it would be quite simple! I was wrong!
In the "Custom Query" box my code looks like:
SELECT * FROM 2000prods WHERE (Field14 LIKE '%::Field14::%') ORDER BY Field14 DESC
I hope someone out there can help as this would save me a hell of a lot of work!
Cheers
|
|
|
|
BeTheBall
Posts: 6502
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Unique Records? - 2/11/2009 19:20:31
You need to use DISTINCT in you query. However, I am not sure you can use DISTINCT with the wildcard (*). I think you have to specify which field you want to be distinct. So you may have to list the individual fields in your SQL. For example:
SELECT DISTINCT Field1, Field2, Field3 FROM 2000prods WHERE (Field14 LIKE '%::Field14::%') ORDER BY Field14 DESC
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 