Skip to content

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

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

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 ,