Table not updating (Anyone Please Help)

[goyal_cyber]

I have a database whose Table is not Updating. The Query data is not updatable. I am attaching herewith the database and request the members in this forum to help me.

[pbaldy]

I don't have time right now to download the sample, but you can probably find the reason here:

http://allenbrowne.com/ser-61.html

[goyal_cyber]

I tried my best but could not create an sql formula as I don't know sql. Kindly reply when you are free. Thanks for giving time.

[pbaldy]

If you mean the DP-CON query, it includes a GROUP BY clause. As noted on that link, it will not be update-able.

[goyal_cyber]

Thanks for the reply.

I mean to say is that FormDtl is the Master Table where data should be updated from Query2.

Kindly help.

[Access_Blaster]

To get more people to look at your DB you may want to convert it to something like Access 2000. Not everybody has made the plunge to 2007.

[goyal_cyber]

I want to inform all members that the DB is in Access 2002-2003.

DP-CON is for Duplicate Records finder.

I want to update Table FormDtl from Query2.

Kindly reply.

[pbaldy]

I'm not sure it's mentioned in that link, but it is in others:

When the query includes more than one table or one query, and the tables or the queries are not joined by a join line in Design view, you cannot update data in the query. To resolve this problem, you must join the tables correctly so you can update them.

From:

http://support.microsoft.com/default...b;en-us;328828