I am working in Microsoft Access 2016. I have a data table [Data] that contains many thousand rows of data. I have a lookup table [Lookup] that contains all of the project IDs that are known. These tables should combine on the project ID, which is a string field. Normally, I would join these tables using: The issue is that
Tag: ms-access
Microsoft Access – How do I import data to an existing Table and update the data
simple yet, a question I can not find an answer too. I am currently importing RAW Data from Excel to my ACCESS database. Every day, this RAW data I receive updates in status. I have a field/key that never changes for example a Document number. However, fields like “Status” and “quantity” can change based on a given situation. Is there
SQL SUM of Article-Prizes
i’m an absolute newbie in SQL and want to add up all the Sums of the Articles * ordered amount to a final prize. I tried to calculate the Articles * amount to the “Gesamtpreis” and then the Method SUM() to sum up all the “Gesamtpreis”. Dont worry, the SQL-Code is auto-generated by Access. Main Problem: Whole Code: Answer When
No value given for one or more required parameters adodb access error
I am trying to assign archival id in my database to the corresponding file number column through an Excel userform. It should find the largest alphanumeric string in the column, and increment it by 1 …
Selecting additional data/values to display as column in query or in form
I have an employee index, that I need to run queries on for each employee, and display that output along with the original employee. So say the employee index has an ID, batch, status, and multiple other columns. I have a table where I keep track of every time a column in the employee index changes. I want to display
Access database presenting date in ddmmmyyyy format
I have an Access DB where its date is given in ddMMMyyyy (ex: 27SEP2020). Each time I try and set the data type as a date, it deletes the entire column of over 450 entries. Is there a way to either …
It is possible to create an Subdatasheet in ODBC?
Basically, I’m trying to manage a stock warehouse, and what I’m curious about is that it is possible to implement subdatasheet inside the linked table? I have found multiple of articles regarding to …
MS Access SQL query a table and remove duplicates
I have reviewed several posts here and can’t find the answer, but it may be that the problem and answer are a bit above my pay grade. I have an MSAccess Table with two ID fields (ID1 and ID2), and …
“Operating system is not presently configured” error with Access ODBC
I get this error when I try to connect to Microsoft Access Database via Python. The code has been working all the time and only started popping the today. Can someone please guide me to why the problem may be occurring now? I tried doing this “Operating system is not presently configured” error with Access ODBC even after removing the
VBA 3131 error in SQL using variables in query
Can you please help me? I was trying to figure it out for about 2 hours but I still have some error in the syntax. I have the following code with String variables which I need to pass into the SQL …