This Recordset is not updateable.

[dynamite9585]

i have an issue with a query i am running. the idea is "this list of people can do this course"
you click on who you want to do the course and i will work out the rest of the problems from there. but everytime i check "tempattend" i get this recordset is not updateable.

could it be because the query used data from 2 tables? or that "tempattend" is used for another function (that is working well)

SELECT [Personal Info].Rank, [Personal Info].[Last Name], [Personal Info].[First Name], AttandacetrackerQuery.Paradecount, Age([Personal Info]![DateOfBirth]) AS Age, [Personal Info].Prof, [Personal Info].Basic2, [Personal Info].JNLDR, [Personal Info].tempattendance
FROM AttandacetrackerQuery INNER JOIN [Personal Info] ON AttandacetrackerQuery.CDTID = [Personal Info].[Cadet Number]
WHERE ((([Personal Info].Rank)="CDT" Or ([Personal Info].Rank)="LAC" Or ([Personal Info].Rank)="CPL") AND ((AttandacetrackerQuery.Paradecount)>1) AND ((Age([Personal Info]![DateOfBirth]))>1) AND (([Personal Info].Prof) Is Not Null) AND (([Personal Info].Basic2) Is Not Null) AND (([Personal Info].JNLDR) Is Not Null) AND (([Personal Info].SNLDR) Is Null) AND (([Personal Info].Active)=Yes));

 

[Khalid_Afridi]

Hi, Welcome to AWF

There are multiple reasons why records are not updatable?
is your query is lying under the above conditions?

 

[boblarson]

One reason is this part:
Age([Personal Info]![DateOfBirth]) AS Age