1. Home

MS Access query that includes a join to itself (using a subquery) and reports values that do not exist (null values)

I have the following table named PRICES: VERTEXID TIMEID PRICE 6001 20191231 104.3 6001 20181231 115.3 6001 20171231 138.3 6001 20161231 122.3 6002 20191231 102.3 6002 20190931 123.3 6002 …

Run-Time Error ’13’ Type Mismatch – ACCESS DATABASE

I am trying to compare two text fields txtTrailerNumber and txtSealNumber to the database table Tab_TrailerDetails. [TrailerNumber] and [SealNumber] as listed in the table. I am trying to get the …

SQL syntax for characters not in brackets

I’m accessing a Microsoft Access database using ODBC. According to the w3schools SQL tutorial, the ANSI-92 wildcard for “any character not in brackets” should be ^. However, their own …

Formatting in MS Access

I am trying to format a Access table fields to include all values as in the images below. However when I copy and paste from excel to the Access table, only significant figures appear in the table. …

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 …

Extract partial data from a column using SQL (and maybe regex)

I’m working with SQL in MS Access. One of the columns that I import from Excel has date and time in an odd format as below: Jan 12 2021 07:55:14 AM PST MS Access doesn’t recognize this as date and …

Access: Issue Creating SQL View Through VBA – Unions not allowed in subquery

First of all, let me preface this with something I almost always say in my few posts so far, which is that I’m not an IT/tech person. I’m an accountant who likes to dabble a little bit in SQL and so …

ms access, need to get all rows with a distinct column

I have a table called “parts” which stores information on electrical connectors including contacts, backshells etc. all parts that are part of an assembly have a value in a column called &…

Select Top X records starting at record Y

I am using MS Access VBA to make a few queries. I have a list of about 4000 items and I need query 1 to be the top 739 items and query 2 to be the top 428 items starting at record 740 and I need query …

Convert columns to rows and get the sum of checkboxes in Access

I have an Access database that has checkboxes in on of the tables. I need to get a Sum of the checkboxes but, I want to convert the checkbox columns into rows instead of columns. Here is an example …