I have a table that holds records for each job, incuding total hours allowed for each dept called Original
I have a table where each record has the job #, dept and time allowed. We do engineering so a job may have 2 gears to be made, each with its own time allocations call Job Details.
I have an input form for the job with a subform for input of the dept and op time.
Either on exit from subform or on current on main form, I wish to run the following update query.
UPDATE Original INNER JOIN [Job Details_Crosstab] ON Original.[Job #] = [Job Details_Crosstab].[Job #] SET Original.FAB = [Job Details_Crosstab]![FAB], Original.SAW = [Job Details_Crosstab]![SAW], Original.TURN = [Job Details_Crosstab]![TURN], Original.MILL = [Job Details_Crosstab]![MILL], Original.CNC = [Job Details_Crosstab]![CNC], Original.Drill = [Job Details_Crosstab]![Drill], Original.GEN = [Job Details_Crosstab]![GEN], Original.SLOT = [Job Details_Crosstab]![SLOT], Original.FITT = [Job Details_Crosstab]![FITT], Original.CylGr = [Job Details_Crosstab]![CylGr], Original.ThrGr = [Job Details_Crosstab]![ThrGr], Original.ProfGr = [Job Details_Crosstab]![ProfGr], Original.INSP = [Job Details_Crosstab]![INSP], Original.Misc = [Job Details_Crosstab]![Misc]
WITH OWNERACCESS OPTION;
the Job Details_Crosstab is as follows
TRANSFORM Sum([Job Details].Hours) AS [The Value]
SELECT [Job Details].[Job #]
FROM [Job Details]
WHERE ((([Job Details].[Job #])=[Forms]![Quick Card]![Job #]))
GROUP BY [Job Details].[Job #]
PIVOT [Job Details].JobType In (“FAB”,”SAW”,”TURN”,”MILL”,”CNC”,”Drill”,”GEN”,”SLOT”,”FITT”,”CylGr”,”ThrGr”,”ProfGr”,”INSP”,”Misc”,”Goods In”,”Packing”,”TRUCK”);
but when I run it I get the following Error
Operation must use an updateable query.
I don’t understand this message, what am I doing wrong??
Regards, Allan