Cannot edit from query results

Fox66

Registered User.
Local time
Today, 04:18
Joined
Feb 17, 2004
Messages
13
Hi,
I have a query that references 2 tables.
the query works fine, extracting the required records, however, when I view the results, I then cannot edit the selected records, I just get an annoying "ding" from my PC. I am sure this used to work fine, I think I have done something to stop editd, but cannot find what. Query below:

SELECT Customers.Customer, Faults.ID, Faults.Customer AS Faults_Customer, Faults.Date, Faults.Time, Faults.Fault, Faults.Clear, Faults.ClearDate, Faults.ClearTime, Faults.Code, Faults.ReportedBy, Faults.Closed, Faults.Status, Faults.Category
FROM Customers INNER JOIN Faults ON Customers.ID = Faults.Customer
GROUP BY Customers.Customer, Faults.ID, Faults.Customer, Faults.Date, Faults.Time, Faults.Fault, Faults.Clear, Faults.ClearDate, Faults.ClearTime, Faults.Code, Faults.ReportedBy, Faults.Closed, Faults.Status, Faults.Category
HAVING (((Faults.Closed)=No))
ORDER BY Faults.Category;

Any help appreciated before I boot my PC across the car park.
Thanks
 
Also, if it helps at all, I also have a button on a form that uses the query to save the current record and force the form to re-query.
if I click this button I get the message
"The command or action "SaveRecord" isnt available now"

Cheers
 
I am sure this used to work fine, I think I have done something to stop editd,

No, you haven't. A Totals query is not updatable.
 
Last edited:
Doh!
Thanks for the reply,
In the end I rebuilt the query from scratch and now its fine
 

Users who are viewing this thread

Back
Top Bottom