MS Access board?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: MS Access board?

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there an MS Access board similiar to this one?

    I am trying to keep duplicate records from showing in a query I am running from two tables and have not been able to find out how to keep them from showing.

    If anyone can point me in the right direction, I would appreciate it.

    Thanks,

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    East Sussex
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks a lot. I also found another board at:
    http://www.access-programmers.co.uk/...i/Ultimate.cgi

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    MarkW once gave me a link to a site. I looked in my favorites and thought this was it, but I went to it and I couldn't find it.

    Anyway, have you tried adding the Sums row to the detail area, and selecting Group By for the things that you want to show up only once, and Sum for the numbers you are totalling?


    http://www.elementkjournals.com/prod...onal+Computing

  6. #6
    Guest

    Default

    On 2002-03-12 12:52, J Lowe wrote:
    Is there an MS Access board similiar to this one?

    I am trying to keep duplicate records from showing in a query I am running from two tables and have not been able to find out how to keep them from showing.

    If anyone can point me in the right direction, I would appreciate it.

    Thanks,
    In your query, in Design View, click on the title bar of the query window, and then click on the properties icon (or go to View-Properties). In the properties box, change Unique Values to "yes".

    Hope this helps,

    Russell

  7. #7
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, last post was me. I hate it when I do that!

  8. #8
    New Member
    Join Date
    Apr 2003
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default THANK YOU!!!

    Quote Originally Posted by Anonymous
    In your query, in Design View, click on the title bar of the query window, and then click on the properties icon (or go to View-Properties). In the properties box, change Unique Values to "yes".

    Hope this helps,

    Russell
    Russell Hauf,

    THANK YOU so much!! I've been trying to fix this query for weeks. Unfortunatly I've had to learn Access on my own by trial and error after using another relational database for years that is much different.

    Again, thanks for taking the time to post this!

    -Z

  9. #9
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com