Skip to content
Advertisement

Tag: ms-access-2010

Unpivot or transform data using MS Access Query

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

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

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 ,

Advertisement