query update

  1. D

    Help with power query

    Hello, New to the forum. I'm having issues with query updates. I've created a query and moved things around a bit, added new columns and rows for totals and titles but now if I update the query it erases all of the changes and formatting I made outside of the query and just displays the...
  2. M

    Excel Connection SQL Server - multiple query updates

    I have a workbook with a bunch of different SQL queries that I'm trying to update simultaneously. All the queries are very similar I just need to change a number in 12 different ones. I’ve been going in to each one through Connections>properties>definition>commandtext<o:p></o:p> Rather than...
  3. O

    Update query criteria code using variables

    My spreadsheet contains a query from an Access database. I recorded a macro to edit the query's criteria. The code is copied below. This works fine whilst the criteria are hard coded into the macro. However, I want the criteria to come from variables (via inputboxes or userform) so that the user...
  4. O

    update query doesn't update

    When I run this query, access pulls over 385 records: select * from dbo_MenuItem WHERE dbo_MenuItem.Primary_Vendor=18 AND dbo_MenuItem.Price_6=0.53 AND dbo_MenuItem.PLU Like "b%" AND dbo_MenuItem.Price=0.59; But, when I run this query, it says it will update 0 records update dbo_MenuItem...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top