I want to get int using this query: “SELECT int(Abs(x1-x2)+0.5) AS len, Count(*) AS num FROM Coordinates GROUP BY int(Abs(x1-x2)+0.5) ORDER BY int(Abs(x1-x2)+0.5) ASC;”; int …
Tag: ms-access
Syntax error Missing operator in my case statement
I got an error with the below SQL I wrote in ACCESS, where is my mistake? I’ve other when statements to add UPDATE daily_inventory t0 SET t0.Type = CASE WHEN t0.[item number] LIKE “*-FG-*” …
MS-Access Query to PostgreSQL View
I am converting a microsoft access query into a postgresql view. The query has obvious components that I have found reasonable answers to. However, I am still stuck on getting the final result: …
Do I need both conditions in IIf function?
I know the syntax of the IIf function in SQL is IIf(Boolean_Expression, True_Value, False_Value) But I just found a SQL Code where is written IIf([DATE_USER_TO_SPECIALIST] Is Not Null, Year([…
Running total in Access Query based on item and date
I’m struggling with an Access Query trying to create a calculated field which presents a running total of parts that have gone or returned in the store; sorted in the order of date in one table. The table “DMPartsT” would look like below: The result I am aiming for is for the query to return…
VBA SQL: Syntax Error in From Clause, Double Inner Join with Password
I’m reasonably new to SQL and I’m trying to create a string that collects the following: Code from [Catalogue Info] as c Description from [Product Information] as p Weight from p PPB from p CP-UK …
Cycling through Table Defs and Deleting
I have a subroutine that runs on a local copy of a database and a network stored master. To allow users to run my Excel add-in offline, I create a local version that has the same table names as the …
Duplicate records in all related Access tables with new PK/FK assigned at button click event
I have an Access database with 5 tables: Report_Start holds PK on [Report_ID] CommSummary holds FK on [Report_ID] MRPCSummary holds FK on [Report_ID] SQESummary holds FK on [Report_ID] MEPSummary holds FK on [Report_ID] Report_ID links tables 2-4 to Table 1. User enters new report info on a user form (Report …
How do you return the max of a column (Text field)? [closed]
I can not find a way to execute the following simple query: SELECT max(@SomeCol) FROM test_table; I can do just about everything else except for that, max doesn’t return what I expect.
SQL code patterns mapped to Matlab operations on `table’s`
I’m quite comfortable (and somewhat critically dependent) on Microsoft Access (SQL 92) code idioms patterns, including nested SELECTs, various JOINs, filtering, column ordering, and aliasing of …