Linking Query to table

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?????
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oops! Didn't check "Save password" when linking tables. What now? 2
Table Linking and Queries?? 1
Query results from joined table 2
Query/Juntion table question 7
Query Question 3
Continued frustration with relationships and queries 1
Access Command button to look up and copy data from a query to a table 0
Form view and fields based on query 2

Top