View Full Version : Query doesn't allow edits.


yeppy12
03-02-2010, 07:37 AM
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.

SOS
03-02-2010, 07:39 AM
Check this out and see if it helps:
http://allenbrowne.com/ser-61.html

pbaldy
03-02-2010, 07:40 AM
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.

yeppy12
03-02-2010, 07:57 AM
Thank you all for the help. It was a group by clause in one of my queries.