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
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