Quote:
quote:Originally posted by erin
I created input form in asp page and I am storing the entries in the access database and displaying the data on the web.
|
Run the query in the database directly to insure you are getting output from your data. This will help to figure out if the problem is in your ASP code and/or how you are connecting to the database.
Quote:
quote:
I don't want to display any duplicate record if exists in the X,T and P columns.
|
Yes, you've said that many times. The query I gave you will do that.
Quote:
quote:
I use 'distinct clause' but it eliminates all the duplicate records in the database. So for no luck
|
Have you been following along in this thread? Nowhere has anybody suggested that the DISTINCT clause will do what you need. If you don't wish to follow the suggestions, then good luck and I wish you well in your attempts to solve your problem on your own.
Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
