M
mewins
For some reason, I can’t filter my pivot table on certain computers.
I have the following query:
SELECT [FirstName] & " " & [LastName] AS [Client Name], tblTasks.Task,
tblTasks.AssignDt, tblTasks.Staff, tblTasks.TaskDueDt FROM tblMainClientInfo
INNER JOIN tblTasks ON tblMainClientInfo.ClientID = tblTasks.ClientID WHERE
(((tblTasks.DtTaskComp) Is Null)) GROUP BY [FirstName] & " " & [LastName],
tblTasks.Task, tblTasks.AssignDt, tblTasks.Staff, tblTasks.TaskDueDt;
On the computers in my office, I can filter by tblTasks.Staff just fine, but
when I take this query to other computers in a different branch office, I
can’t filter at all. This only seems to happen with this one query. Other
queries I can filter, but this one for some reason won’t. I will be able to
see the different options, but I can’t (de)select Staff in the list. I’ve
tried re-creating the query from scratch with no improvement. The computers
in question tend to be older, often running Windows98 or NT (though some are
XP), and they all run Access 2003. Any ideas? Thanks!
I have the following query:
SELECT [FirstName] & " " & [LastName] AS [Client Name], tblTasks.Task,
tblTasks.AssignDt, tblTasks.Staff, tblTasks.TaskDueDt FROM tblMainClientInfo
INNER JOIN tblTasks ON tblMainClientInfo.ClientID = tblTasks.ClientID WHERE
(((tblTasks.DtTaskComp) Is Null)) GROUP BY [FirstName] & " " & [LastName],
tblTasks.Task, tblTasks.AssignDt, tblTasks.Staff, tblTasks.TaskDueDt;
On the computers in my office, I can filter by tblTasks.Staff just fine, but
when I take this query to other computers in a different branch office, I
can’t filter at all. This only seems to happen with this one query. Other
queries I can filter, but this one for some reason won’t. I will be able to
see the different options, but I can’t (de)select Staff in the list. I’ve
tried re-creating the query from scratch with no improvement. The computers
in question tend to be older, often running Windows98 or NT (though some are
XP), and they all run Access 2003. Any ideas? Thanks!