Query with DISTINCT on access database
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Query with DISTINCT on access database

Hybrid View

  1. #1
    Join Date
    Dec 2005
    Posts
    30

    Query with DISTINCT on access database

    I'm having trouble with my query statement. I'm pasting tables image bellow.

    Name:  distinct.jpg
Views: 48
Size:  83.9 KB

    I would like to remove duplicates based on ID_narocila column and select all items that are written in my sql statement. Can you please help me with the query.

    Thanks.

  2. #2
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,090

    Re: Query with DISTINCT on access database

    This should have been compensated for before creating the database. If you had set up your Db not to accept duplicates, there wouldn't have been a problem, IMHO. You could have used the Indexed property of the Access field to set this up

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center