471,854 Members | 1,921 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,854 software developers and data experts.

The Microsoft Access Database Engine does not recognize

I use Access at work, I'm mostly self-taught and I know very little code . I've built a data base for handling HR KPI´S. In some of my queries, since 2016 started (2015 still runs), several reports I run now pops the error: "The Microsoft Access Database Engine does not recognize 'C_Hrs_Permiso_TI_NT.NOTRAB' as a valid field name or expression". I'm not sure why the report would be giving me an error about it.
Query Code:
Expand|Select|Wrap|Line Numbers
  1. TRANSFORM Sum(Hrs_Permiso_TI_NT.MONTOO) AS SumaDeMONTOO SELECT Hrs_Permiso_TI_NT.EMPRESA, Hrs_Permiso_TI_NT.CENCOS, Left([Hrs_Permiso_TI_NT]![AMES],4) AS Año, Right([Hrs_Permiso_TI_NT]![AMES],2) AS Mes, Hrs_Permiso_TI_NT.CODIGO, Fecha_maxmes_Calendario.MáxDeFecha FROM Hrs_Permiso_TI_NT INNER JOIN Fecha_maxmes_Calendario ON Hrs_Permiso_TI_NT.AMES=Fecha_maxmes_Calendario.Ames GROUP BY Hrs_Permiso_TI_NT.EMPRESA, Hrs_Permiso_TI_NT.CENCOS, Left([Hrs_Permiso_TI_NT]![AMES],4), Right([Hrs_Permiso_TI_NT]![AMES],2), Hrs_Permiso_TI_NT.CODIGO, Fecha_maxmes_Calendario.MáxDeFecha PIVOT Hrs_Permiso_TI_NT.COHADE;
Jan 27 '16 #1
0 1150

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

NeoPa
reply views Thread by NeoPa | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.