Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Query/Table Problem

Status
Not open for further replies.
Feb 25, 2004
5
US
Fairly new to Access. I have linked two tables and created a query using both tables. I created a form to enter the data to that query. However, the data isn't stored in that query. It does appear in the two seperate queries and tables. I had this working before, but now the new entries just do not get stored in the linked query. What have I done wrong.

Thanks,
Keith
 
Hi

Data does not get stored in Queries. It is stored in tables.

Tables are physical entities containing data, queries are logical presentations of that data which are created 'on the fly' when you run the query, and destroyed when you close the query

As to why the data is not appearing in the query you mention it is not possible to say without knowing the table structure and the query structure/SQL

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top