G
Guest
I have a really strange problem.
A couple of my queries have stopped showing new data. If I look in the table
itself the data is there. If I open the form, the data is there. If I open
the query that the form is based on, the data is there.
If I open the query that the report is based on, it shows the first 69
records and no more. I've tried rebuilding the query and it still only shows
the first 69 records. The query has quite a few joins. Is it too complex for
it to return any more records?
SELECT WorkOrder.WorkOrderID, WorkOrder.JobNumber, WorkOrder.OrderDate,
WorkOrder.Address, WorkOrder.Deadline, WorkOrder.ClientJobNumber,
WorkOrder.PriorityID, WorkOrder.EmployeeID, WorkOrder.ReportFault,
WorkOrder.Complete, WorkOrder.[Completion Date], WorkOrder.Notes,
Employees.EmployeeID, Employees.FirstName, Employees.LastName,
Priority.PriorityID, Priority.PriorityDescription,
WorkOrder.AccessContactName, WorkOrder.AccessContactNumber,
WorkOrder.KTFContactName, WorkOrder.Address2, WorkOrder.City,
WorkOrder.County, WorkOrder.PostCode
FROM Priority INNER JOIN (Employees INNER JOIN (WorkOrder INNER JOIN
(ScheduleOfRates INNER JOIN WorksDetail ON ScheduleOfRates.SORCode =
WorksDetail.SORCode) ON WorkOrder.WorkOrderID = WorksDetail.WorkOrderID) ON
Employees.EmployeeID = WorkOrder.EmployeeID) ON Priority.PriorityID =
WorkOrder.PriorityID
GROUP BY WorkOrder.WorkOrderID, WorkOrder.JobNumber, WorkOrder.OrderDate,
WorkOrder.Address, WorkOrder.Deadline, WorkOrder.ClientJobNumber,
WorkOrder.PriorityID, WorkOrder.EmployeeID, WorkOrder.ReportFault,
WorkOrder.Complete, WorkOrder.[Completion Date], WorkOrder.Notes,
Employees.EmployeeID, Employees.FirstName, Employees.LastName,
Priority.PriorityID, Priority.PriorityDescription,
WorkOrder.AccessContactName, WorkOrder.AccessContactNumber,
WorkOrder.KTFContactName, WorkOrder.Address2, WorkOrder.City,
WorkOrder.County, WorkOrder.PostCode;
A couple of my queries have stopped showing new data. If I look in the table
itself the data is there. If I open the form, the data is there. If I open
the query that the form is based on, the data is there.
If I open the query that the report is based on, it shows the first 69
records and no more. I've tried rebuilding the query and it still only shows
the first 69 records. The query has quite a few joins. Is it too complex for
it to return any more records?
SELECT WorkOrder.WorkOrderID, WorkOrder.JobNumber, WorkOrder.OrderDate,
WorkOrder.Address, WorkOrder.Deadline, WorkOrder.ClientJobNumber,
WorkOrder.PriorityID, WorkOrder.EmployeeID, WorkOrder.ReportFault,
WorkOrder.Complete, WorkOrder.[Completion Date], WorkOrder.Notes,
Employees.EmployeeID, Employees.FirstName, Employees.LastName,
Priority.PriorityID, Priority.PriorityDescription,
WorkOrder.AccessContactName, WorkOrder.AccessContactNumber,
WorkOrder.KTFContactName, WorkOrder.Address2, WorkOrder.City,
WorkOrder.County, WorkOrder.PostCode
FROM Priority INNER JOIN (Employees INNER JOIN (WorkOrder INNER JOIN
(ScheduleOfRates INNER JOIN WorksDetail ON ScheduleOfRates.SORCode =
WorksDetail.SORCode) ON WorkOrder.WorkOrderID = WorksDetail.WorkOrderID) ON
Employees.EmployeeID = WorkOrder.EmployeeID) ON Priority.PriorityID =
WorkOrder.PriorityID
GROUP BY WorkOrder.WorkOrderID, WorkOrder.JobNumber, WorkOrder.OrderDate,
WorkOrder.Address, WorkOrder.Deadline, WorkOrder.ClientJobNumber,
WorkOrder.PriorityID, WorkOrder.EmployeeID, WorkOrder.ReportFault,
WorkOrder.Complete, WorkOrder.[Completion Date], WorkOrder.Notes,
Employees.EmployeeID, Employees.FirstName, Employees.LastName,
Priority.PriorityID, Priority.PriorityDescription,
WorkOrder.AccessContactName, WorkOrder.AccessContactNumber,
WorkOrder.KTFContactName, WorkOrder.Address2, WorkOrder.City,
WorkOrder.County, WorkOrder.PostCode;