Tag: ms-access-2016

Insert Query only inserting the first value?

ms-access ms-access-2016 sql sql-insert vba

I looked around quite a bit figuring someone else must have had this issue, but I didn’t see it. It’s driving me nuts, that something so simple isn’t working and I can’t figure out why, and so I’ve spent 3 hours now on something that should have taken a couple minutes… So here’s the set up. I have a query

SQL query to combine the results from two tables

ms-access-2016 sql

I have these two tables and I want to build a SQL query: My search criteria is: Name (in field Brother and field Speaker) Congregation (in field Congregation in both tables) I want the resulting view to be a single list of all records, sorted by date (fields Talk Date and Last Given). So: Away Talks I am interesting in

SQL Query with criteria of 6 chars and wildcards

ms-access ms-access-2016 sql

I’m stuck with an SQL query to get what I need. My input is this: COD SINOM A 123456 B 987654, 123456, 111111 C 123456 , 234501 D 9912345699 E 99123456, 789012 F 77123456 Both fields are …

Microsoft Access 2016 – Need to combine SQL query using JOIN …. ON Col1 MOST LIKE Col2

database ms-access ms-access-2016 sql sql-like

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

Selecting additional data/values to display as column in query or in form

ms-access ms-access-2016 sql vba

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

SQL string in access VBA not behaving as expected

ms-access ms-access-2016 sql vba

I have a bit of access VBA that for the life of me, I cant work out what is wrong. First off, here is the offending section of code, and I’ll explain what I want and what it’s doing below. …

Access/SQL: How can I check if in a table all duplicates (same date) have a value of 0 except one?

ms-access ms-access-2016 sql

I have a table in Access (tblExample) which consists of the fields ID, tripID, day and value. This table is edited by a form. When the user closes the form Access should validate the entries made. It is ok to have multiple records of the same date in day. BUT…if there are multiple records of the same date only one