where query

  1. Z

    Variable in where statement of database query SQL

    I am trying to make a tool based using databases. What i need to do is create a connection query based on a user input. I can get it all to work until i try to add variables into the where statement at the end of the SQL string. Here is the beginning of the code that I have...
  2. S

    conditional mode question

    I have a question about how to get the most frequently occurring group id for each output area. There are 400+ individual output areas in my list (of 3k+ repeated values) and I need to find the most frequently occurring group for each output area. I created a new list of output areas - with...
  3. G

    VAT Lookup Query

    Hi Guys, I hope someone can help me with this query! I have a badly written database to fix, I have invoice generating queries that contain the code VAT: IIf([VAT Applicable]=True,[Amount]*0.175,0) If i simply change all of the queries to 15% the historical data will be affected, so I need...

Watch MrExcel Video

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