Different Versions Have Different Capabilities

I am using this query in Access 2003, and even though there are joins on
multiple tables, the only fields I make updateable only the fields in the
last "many" table, it does allow updating. However, I run this on a machine
with an earlier version of Access, and it does not. Should this be allowed
to work in both versions?

SELECT DISTINCTROW [FirstName] & " " & [LastName] AS FullName,
T_ClientPayments.Amount, T_ClientPayments.PaymentType,
T_ClientPayments.DateProcessed, T_ClientPayments.NumberPayment,
T_ClientPayments.Processed, T_ClientPayments.PaymentDate,
T_ClientPayments.Notes, T_Classes.ClassName, T_ClientClasses.SalesRep,
T_ClientPayments.ClientClassID, T_ClientPayments.ClientID,
T_Clients.LastName, T_Clients.FirstName, T_ClientPayments.MassUpdate
FROM T_Classes INNER JOIN (T_Clients INNER JOIN (T_ClientClasses INNER JOIN
T_ClientPayments ON T_ClientClasses.ClientClassID =
T_ClientPayments.ClientClassID) ON T_Clients.ClientID =
T_ClientClasses.ClientID) ON T_Classes.ClassID = T_ClientClasses.ClassID
WHERE (((T_ClientPayments.DateProcessed)>=BeginDateFilter() And
(T_ClientPayments.DateProcessed)<=EndDateFilter()))
ORDER BY T_ClientPayments.PaymentType;


.

Relevant Pages

  • RE: Form For Crosstab Query
    ... My next step is to place the query on a continuour form, and add a command ... FROM (TimeRecords INNER JOIN Staff ON TimeRecords.StaffID = Staff.StaffID) ... I would like to add an additional column that sums the multiple of each ...
    (microsoft.public.access.forms)
  • Re: correlated subquery in the crosstab
    ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... I have students, courses, exam groups containing exams of courses, ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)
  • Re: correlated subquery in the crosstab
    ... I solved my problem using stored queries to act as subqueries. ... FROM (tblStudent INNER JOIN (tblClass INNER JOIN ... values from the outer query and I have made an alias for it. ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)
  • RE: VBScript Problem with Access Query (Unspecified error)
    ... some records from the multiple tables using Inner Join. ... absolutely fine when i execute the query in MS access 2003. ... Set conn = CreateObject ... JOIN AllEmployees ON SenderToDom.Sender = AllEmployees.Email) INNER JOIN ...
    (microsoft.public.scripting.vbscript)
  • Re: correlated subquery in the crosstab
    ... The first query ... TRANSFORM FirstAS FirstOfscore ... FROM tblStudent INNER JOIN (((tblEduYear INNER JOIN tblExamGrp ON ... that the crosstab query in access has much more capablities than ...
    (microsoft.public.access.queries)