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 …

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 …

How to display a list of departments whose teachers teach DBMS department students?

I have a database in Access. The database has 4 tables: [DEPARTMENT], [TEACHER], [LECTURE], [SGROUP]. I need to display a list of departments whose teachers teach DBMS department students. The …

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 …

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 …

convert access group by query to sql server query

I’m unable to convert MS Access query to SQL SERVER Query, with changing the group by columns because it will effect in the final result. The purpose of this query is to calculate the Creditor and …

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

Calculate sum of duration SQL

I use the following sql to calculate the duration in the first query. CDate(TimeSerial(Val([EndTime])100,Val([EndTime]) Mod 100,0)-TimeSerial(Val([StartTime])100,Val([StartTime]) Mod 100,0))) AS …