SQL Query with criteria of 6 chars and wildcards

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 …

SQL string in access VBA not behaving as expected

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. …

How can I get a record to be counted in multiple columns of a Crosstab Query?

Background information: My company requires employees to maintain at least one certification (cert) on a position. There are a total of 17 different certifications that an employee can get. An …

Error 424 object required after NULL SQL query

I am running some EXCEL VBA code to update the contents of an ACCESS database table along the lines suggested here: IF @@Rowcount = 0 — SQL Syntax Error in Access . When I execute the SELECT query, …

MS Access 2016, joining multiple tables with composite keys

Good Morning all, My first question, so pardon some bad form if it exists. I currently have three tables (table1, table2, table3), all of which have a composite primary key (model-number, serial-…