Good afternoon guru’s! I’m hoping someone with Access & SQL experience (and time) would be able to write some SQL code that I could use in MS Access to transform/unpivot some data. I guess it’s a bit like a an unpivot. Current table “tbl_Weekly_Forecast” is structured like this; Desired query output is like this; There are actually 24 columns to
Tag: ms-access-2010
Unpivot Data Using MS Access Query
Hoping someone with Access & SQL experience would be able to write some SQL code that I could use in MS Access to transform/unpivot some data. I’ve spent a day trying advise from others who have asked similar questions here, but I have no SQL experience and have failed miserably so far. Answer You can use union all to unpivot
Access using an SQL JOIN or similar statement as a record source for a report
SELECT * FROM QryMain WHERE [Plant Number] IN (SELECT [Plant Number] FROM [QryProceduresDone]); Hi all. Currently using the above as a report record source. Basically I want the report to show …
Keeps counting all the text values instead of me providing a criteria in SQL
I have very simple query, to count the number of Cause Cancel from the Decision column. It keeps counting all the text values in the column and not just cause cancel. Answer I think you want a WHERE clause not a HAVING clause:
Access Unmatched or similar query where a column does not contain or is not like another column
I want to design a query that basically does a mass amount of “Not Like “*x*”, except all of the things I would not like the query to contain are in another column. I know I can do this one at a time …
MS Access like query with # in the result
I’m just trying to have a query that searches for “#” in a field. SELECT dbo_PartNumber.* FROM dbo_PartNumber WHERE (dbo_PartNumber.[Part Number] like “*#*”);
ms-access-2010 returns #func[exclamation mark]
I have a sql-statement which includes a switch, i want to execute on ms-access-2010. sql: SELECT TABLE_1.ID, SWITCH ( (TABLE_3.ID IN (7,8) AND TABLE_1.SOME_COLUMN = 2), (SELECT MAX(TABLE_4.ID)…
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 Date, Vendor, buyer, planner, etc), which is stored in Report_Start
to use module in sql ms-Access-2010
I have defined a procedure in my module, returning the path of the database and I want to use that path in my sql query. Procedure in module : I am using the function above in my sql query : It is giving me the error: “error in from clause” but when I am using it in vba code ,
Not possible to use HAVING clause in transform sql statement?
Is it possible to use the HAVING clause with the transform statement in MS Access 2010? I keep getting “Syntax error in transform statement” My sql is I tried testing the select statement by itself and it works fine Is what I’m trying to do not supported by access? Answer Indeed, Having is not available when executing a Pivot. A