Query doesn't allow edits.

yeppy12

Registered User.
Local time
Today, 12:35
Joined
Sep 11, 2007
Messages
38
I have two queries (A and B) that are each pulling data from the same table. The only difference between the two queries is that query A has 1 parameter and query B has 3. For some reason, I can edit the results from query A in the datasheet view, but I cannot edit the results from query B in the datasheet view at all.

I checked all of the properties between the two queries, and they are all the same. Can someone help me figure this issue out? Any help would be greatly appreciated.
 
Parameters should not affect the ability to edit records. See if you see anything here:

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

If not, post the SQL of the query.
 
Thank you all for the help. It was a group by clause in one of my queries.
 

Users who are viewing this thread

Back
Top Bottom