Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    5

    Unanswered: Query + VBA - please help

    I have a query created that is getting values from one table. I am displaying records by ID number that correspond to a certain date between Oct 2008 and Now and it also displays the client ID based on the criteria for the department ID. I am just wondering if this is possible - instead of the client ID which displays I need to display the first name/last name that actually matches the client ID number. How can I do this, use VBA and create a form that queries from two locations? (as currently all fields are from one form only but the client ID matches a first name / last name fields in another table called Clients). Just not sure exactly how to go about doing this, thanks for any suggestions.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    It doesn't sound like you need VBA. Start a new query, and add both tables. If one doesn't already appear, create a join between the two tables on their respective ClientID fields. You should now be able to pull fields from either table, enabling you to include the name associated with the ID.
    Paul

  3. #3
    Join Date
    Jul 2009
    Posts
    5
    thanks sorry I haven't used access and sql for a long time, worked perfectly appreciate it!

Posting Permissions

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