Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2005
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to build a query (Access 2000)

    Can you help me with the construction of a query.I want to make a query out of 2 tables and to show in this query the number of the call and the call date.My query shows the number of the call, but it does not show the date.
    Obviously i cannot bind the 2 tables together.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sydney, Australia, New South Wales, Australia
    Posts
    251
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: how to build a query (Access 2000)

    In your data the CallID 384 for ClientID 5 (record 320 of CallsClients table) doesn't have a date. It's the only one without a date!
    Peter

Posting Permissions

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