access courses - Query with criteria using in another query

The UK's most regular instructor-led training courses.
Training information: access courses · Access course microsoft training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Query with criteria using in another query

Sinéad has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Sinéad [15 posts] (2007 Jul 20 Fri, 13:58) Reply

Hello,

I have the following problem:

Query 1 with criteria - editable data
Query 2 - editable data

but when I then add a field from Query 1 to Query 2, the data ceases to be editable. Do you think this is a relationship issue?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	6	book now	£214	£230
2003	2008 Nov 5 Wed	Southwark	6	book now	£214	£230
2003	2008 Nov 21 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Nov 26 Wed	Bloomsbury	5	book now	£219	£235
2007	2008 Nov 28 Fri	Bloomsbury	5	book now	£235	£240
Full Schedule: See all 51 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Query with criteria using in another query

by - trainer Richard platinum contributer [812 posts] (2007 Jul 30 Mon, 12:00) Reply

Hi Sinéad,

Sometimes when you build quries that have one-to-many relationships, the query becomes uneditable. There are several other factors that influence this.

In the HELp section of Access, you will find this information.

Look for
"When can I update data from a query?"

or if you go to the index of help, type Query Update, and in the returned list of topics, you will see one called
When can I update data from a query?

Hope that helps.

Regards

Richard