Top "Ms-query" questions

Microsoft Query is a program for retrieving data from external sources into other Microsoft Office programs — in particular, Microsoft Excel

How to add parameters to an external data query in Excel which can't be displayed graphically?

I often use MS Excel's Get External Data to create simple reports - running queries against databases and displaying nicely …

Read More
excel vba excel-2007 ms-query
CountIf formula within MS Access report

Something terrible as happened with my poor attempt at adding a CountIf forumula to my access report. I am trying …

Read More
sql ms-access report ms-query
SUM function in Pivot Table Not Working

I have a pivot table on one sheet that is coming from a Microsoft Query MySQL datafeed on another one …

Read More
mysql sql excel pivot-table ms-query
What is Subqueries syntax for Microsoft Query?

I am trying to do a simple subquery join in Microsoft Query, but I cannot figure out the syntax. I …

Read More
sql excel syntax ms-query
How to create copy of database using backup and restore

Using SQL Server Management Studio 2012, I'm trying to create a copy of a local database. I found a few variants …

Read More
sql sql-server database copy ms-query