query from two table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • didacticone
    Contributor
    • Oct 2008
    • 266

    query from two table

    i was wondering if anyone can help me. id like to create a report that shows data from two tables... i tried creating a query but cant seem to get it to work. i add all the fields i would like from both tables but the resulting query is blank... can anyone help?
  • servantofone
    New Member
    • Apr 2008
    • 33

    #2
    Have you set a relationship between the two tables in the query? Access Help should provide you some insight into how to do this. If it isn't showing any data in the query, it is probably that the fields indicated in the relationship don't match data types, or there are no matching records.

    -Kyle

    Comment

    Working...