473,511 Members | 16,756 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

The Microsoft Access Database Engine does not recognize

1 New Member
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 1239

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

Similar topics

2
3182
by: Alex Vidal | last post by:
Hi, I have windows 2000 server with IIS and I program ASP. I use the string: "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=basedatos.mdb;" to data base Access and it always works ok. But I...
5
4444
by: Dave | last post by:
This is my first .NET project (although I am experienced with VS6 and InterDev). I am simply trying to set up a basic ASPX project and connect to an Access database (following the instructions in...
3
6878
by: Neal | last post by:
Hi All I am trying to connect from ASP.Net app to an Access Db. If i don't specify a userid an pwd.. I get this error The Microsoft Jet database engine cannot open the file 'C:\Documents and...
1
1738
by: Ely | last post by:
Hi I create an expression in a Macro Argument and adding a Where Condition that matches the control name of the form with the report. It was working fin, but I made a change in the report that...
11
3042
by: Tempalli | last post by:
I am using M.S.Access as backend database and able to add records from Excel but not able to Edit & Update the specific record from M.s Access with reference to cell value given in excel. Kinldy help...
0
1574
by: Orgil | last post by:
Hi all, I have just writing a program named "DayBook". I am using MS Access 2003 database and Microsoft .NET C# 2005 (with framework 2.0). MS Access 2003, MS .NET C# 2005 and dotNetFramework2.0...
1
3023
by: inteladu | last post by:
I have created an object TF_T.....and I seem to be stuck at this error....please need some suggestions to overcome this.....please....very very urgent!!! thanks!!!
2
2381
by: Mr Key | last post by:
Hi all, I have a parameter query running from myform named MainForm,(on AC2010) After a selection on the Combox from MainForm I wish I could always open the data according to parametersQuery...
1
4079
by: Paul Howarth | last post by:
Question from a Novice: I have a Query which is based on a Crosstab Query. One of the fields in the Query is "Client". I can "hardcode" a Criteria for the "Client" field and the Query works...
3
19646
by: IsInTrouble | last post by:
My program is working fine (windows forms and access database) and tables that I have done in beginning of the project are also being read and updated. Now I needed to add a new element to a...
1
7081
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7510
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5668
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3225
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3213
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1576
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
781
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
447
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.