I’m using a cloud storage drive to share some complicated Access databases with my coworkers. I’d like the databases to execute directly from the local cloud storage path. C:Usersexample.dude…
Tag: ms-access
Find Recent Frequent Flyers in SQL Database
I need to find a list of frequent flyers in a database. There are 2 important tables: Demographics and Visits. This is what I have so far: It runs and returns people who visited last year 5 or more times. However, what I ACTUALLY want is people who visited 5 or more times, and have at least 1 visit last
How to use VBA variable in SQL string? Enter Parameter Value error
I get a popup box asking for the parameter value for the value of CXIid Enter Parameter Value for CXI00012. I tried ‘ ” & CXIid & ” ‘ but then I get a result of 0 rows being updated. However when I put a value in the where clause or into the Enter Parameter Value prompt I get the
Syntaxerror in CREATE TABLE without any table creation but in procedure creation
I’m using Microsoft Access 2003, new to SQL tho. I have no idea why this wouldn’t work, google won’t help me either. The table “K_Lehrer” exists, and the code I have here is the only thing I wrote. My code is Error (translated): syntax error in create table statement error with code Answer Microsoft Access 2003 does not support stored
Microsoft Access 2016 SQL Unnest Array
I am trying to take a table and in Microsoft 2016 Access and use SQL to unnest a single column into multiple rows instead. It is comma separated. I tried adding Unnest and keep getting errors, maybe I am missing something. This BOGO_Sale.promo_parent_skus is the only column I am trying to unnest into rows. An example of the table is:
How do I check if a variable is null and assign it a value if it is, in an Access query?
I’m not a big Access user, but I need to work with it from time to time. Now I have run into a, for me, completely new task with Access. I can solve this type of problem with SQL in MS SQL Server. But the SQL syntax in Access doesn’t recognise my SQL code at all so I guess it’s
Multiple Join not working on two string attributes
I have the following issue: I have several tables in my Database, in order to check for a specific criteria I have to join several tables, where I use the following statement: This statement fails. But when I remove one the following two join-conditions in the last Left JOIN, it works as intended: F.risk = table10.risk and/or C.v_type = table10.v_type
How to copy Access table to SQL table in C#?
As title says I’ve used odbcconnection to sqlconnection and for the life of me cant get it to work.. Copied a bunch of code from this site but cant get them both to work. The program just hangs so …
How to pass a Variable/Function into SQL Query?
I am attempting to Insert a Row on a Table, but I cannot seem to pass the TASK_ID as a value/variable/function into the SQL Statement. Throughout the application, to acquire TASK_ID, I use: Dim …
search date from date time field query not working
I have below query it print following line by debug. in table the b_date is dateTime field. ( linked table from SQL server in Msaccess) in this table there is data exist with 1/30/2020 2:00:00 PM where fromtime is also 6. why query didn’t return any data? can msaccess cannot search date in datetime field? PS: fromtime is intiger not