User Profile

Collapse

Profile Sidebar

Collapse
joannem
joannem
Last Activity: Nov 19 '08, 11:12 AM
Joined: Apr 1 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • joannem
    replied to Problem with query join(s?)
    in Access
    Inyour query grid right click in the grey area and at the bottom of the list click properties

    You should see a property Unique records set that to no

    Alternatively remove the Distinctrow from your SQL


    this will return all your records and you can start to filter from here


    jo
    See more | Go to post

      Leave a comment:

    • joannem
      replied to Dynamic Linkmasterfields
      in Access
      would a discrepancy in name be an issue

      Me.DeliveryTran s.LinkChildFiel ds = "[DeliveryNoteNo]"


      stSQL = "SELECT [DeliveryNotes].[DeliveryNote],


      jo
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...