I have, what I thought to be, a simple query:
SELECT tblCompanyMonths.ID, tblCompanyMonths.Company, tblCompanyMonths.MonPay, tblCompanyMonths.DueDate, tblCompanyMonths.Amount, tblReportDate.MonthNum
FROM tblCompanyMonths, tblReportDate
WHERE (((tblCompanyMonths.MonPay)=[tblReportDate].[MonthNum]))
By adding the tblReportDate and restricting the query to only the MonthNum in this table the query became un-editable.
Is there a way to make the query editable again keeping the restriction?