Linking Query to table

  • Thread starter Thread starter Beth McLaren
  • Start date Start date
B

Beth McLaren

My created queries that were designed in Desgin view reference the table I
want the information pulled from but when I double click on the query I have
no information coming into the query.....I thought they would automatically
link up...do I need to go and establish relationships?????
 
Beth

Access queries are like "views" or windows, looking at one/more tables. In
addition, queries are like "filters", in that you can specify selection
criteria for those views/windows on your data.

If your query doesn't return any records, this is usually an indication that
the selection criteria exclude all records.

Please post the SQL statement of your query to help us diagnose potential
issues. Open the query in design view, change the view to SQL, copy the SQL
statement, paste into your response.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top