Editing a Query

drums_4_life

Registered User.
Local time
Today, 04:37
Joined
Mar 26, 2011
Messages
14
Hello,

I have a database with two queries that are suppose to be editable.

The first query works just how it is suppose to but the second one does not. I cannot find what is different between the two so i was wondering if some one could help. I have taken a screen shot of each query in design view and datasheet view.

Query that works:
Design View: Design View_Service Set list Query2.jpg
Datasheet View: Datasheet View_Service Set list Query2.jpg

Query that does not work:
Design View: Design View_Musicians for Church Service Query2.jpg
Datasheet View: Datasheet View_Musicians for Church Service Query2.jpg

Please help I am so lost on how to make it work.
Thanks.
 
The astrisk character at the left border of new record position in datasheet view indicates that it is editable.

Does it show any error while attempting to edit the record?
 
Yeah when i attempt to put a name in the query a window pops up and says "field cannot be updated" How can i fix this?
 
I'm not entirely sure if Access is the same as SQL Server (I use those for all my tables) but typically queries with joins in them are not editable. What I have to do to have aggregate information in editable queries is write subqueries. So I'll have


Select A,B,C,D, (Select SUM(E) from Table2 where Table1.D = Table2.D) as SumE
From Table1

This includes no aggregate functions and is really just a simple select statement on one table. That always worked for me.
 
Try establishing relationship between both tables on the Relationships design surface (Tools - -> Relationships).

This action will tell you whether the data in Contact Name field have any problem in them.
 

Users who are viewing this thread

Back
Top Bottom