469,317 Members | 1,894 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

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 KPIS. 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 Ao, Right([Hrs_Permiso_TI_NT]![AMES],2) AS Mes, Hrs_Permiso_TI_NT.CODIGO, Fecha_maxmes_Calendario.MxDeFecha 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.MxDeFecha PIVOT Hrs_Permiso_TI_NT.COHADE;
Jan 27 '16 #1
0 1094

Post your reply

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

Similar topics

1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.