User Profile

Collapse

Profile Sidebar

Collapse
lolab
lolab
Last Activity: May 14 '13, 11:42 AM
Joined: Apr 30 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • lolab
    replied to Distinct Query with Memo Fields
    in Access
    Thank you for the response! Although, I don't fully understand how to use the group by and aggregate functions. I need to look into this option further. However, when testing it I created a backup copy of the database and in doing so the JOIN query (above) worked!!! Access seems to do funny things sometimes I guess. Hope this helps others in the same boat.
    See more | Go to post

      Leave a comment:

    • lolab
      started a topic Distinct Query with Memo Fields
      in Access

      Distinct Query with Memo Fields

      I have looked through old posts on this and haven't found an answer, any suggestions would be great - Thanks.

      Notes:
      ACESS 2007
      distinct_ids = 390 records
      memodata.id = 714 records
      RIGHT JOIN returns 714 records (with SELECT DISTINCT, memo fields are trunctated)

      Code:
      SELECT ids_memodata.*
FROM ids_memodata
RIGHT JOIN distinct_ids
ON ids_memodata.id = distinct_ids.id;
      See more | Go to post
      No activity results to display
      Show More
      Working...