queries

  1. Q

    Show Duplicates Across 2 Queries

    I have 2 queries: Both Queries have the same fields and are based on the same table (tblBusinesses) but have different criteria <tbody> Query Name Criteria OpenBusinesses 'Status' field equals 'Open' ClosedBusinesses 'Status' field is not equal to 'Open' </tbody> Is there a way to find...
  2. A

    How to remove date picker from query fields

    I have various tables with date fields and have recently set all of them to not show the date picker; but the date picker still shows in select queries using those tables (old queries and new queries). Is there a way I can remove it from the queries? The query property sheet doesn't seem to have...
  3. R

    How to get a list of Distinct values from a Table that is itself the output form a query (variable length)

    Apologies for the convoluted title but I couldn't think of a simpler way to put it without losing some fo the problem. Background: I have a sheet that populates two tables by running queries on an SQL database we operate from. It contains information relating to moving goods around a warehouse...
  4. P

    adSchemaTables is missing some types of queries/views

    I've written code in my Excel front-end to list all queries/views in program's backend db (MS Access .mdb file). I've done this by using the adSchemeTables, but I've found that the schema only includes select type queries. The other possible query types (Update, Delete, Append, etc) are *not*...
  5. F

    Table edits not included in query refresh

    I've appended two Excel tables (A and B) using Power Query. So far so good. Table A is a connection only to another Excel file. Table B is in another sheet of the workbook where my query results get loaded. Table B has to be manually updated on occasion - it's a list of exceptions to append to...
  6. M

    Access Query won't run, getting error.

    Hello and thank you in advance if you can help, I am using Access 2019 on a PC. I have a database that under properties is said to have a size of 2.87 MB. All my files are linked, four data files as text imports (two 1 million + records, and the other two small, a few thousand), 8 lookup...
  7. C

    Countifs and indirect references question

    First: Thank you for reading. My issue, I have a formula on a waterfall type report that uses a lot of countif functions to determine if a site is forecasted/actualized, and counts it if it is. I bring in data to the workbook through a series of queries, and unfortunately, the client changes...
  8. C

    Excel Query speeds/running queries in parallel instead of sequentially

    So I have created multiple connections that query an SQL Server and have 2 running when I open the file in the background and then I call the other 4 in VBA since need to identify the user and pass it to the stored procedure it is calling. The issue is that it is slow...really slow. From...
  9. P

    ADO %, * Wild Card confusion

    Hi I've found the workaround for this issue, but don't understand why it was an issue: I did all the hard work of writing the queries in Access and some of the queries involve sub-queries e.g. Pretend I wanted queries that prepared data on Goals, Assists, Wages, Corners So inside Access, the...
  10. M

    Can't see Access queries in the Power Query get and transform for import/link?

    Hello, and thank you in advance for helping if you can, I have created and Access database, and I am trying to link to some of the queries from it in Excel's Power Query. In the get and transform, I can see the database, all of the linked tables, and one query I had created for a union query...
  11. L

    VBA Union Query

    I have a union query with 26 subsequent queries built in Access; however, I get an error saying "System resource exceeded.". I'm assuming I just have too many queries for it to process. If it cut out four of them it works fine. So my question is, can I somehow do a union in VBA with the...
  12. C

    Counting the number of times a cell value changes

    Hello All, I referred to the earlier post from 2004 but didn't post my queries due to aging of the thread but my queries as same, so please help . Earlier Post : https://www.mrexcel.com/forum/excel-questions/67250-counting-number-times-cell-value-changes.html I tried using the VBA given in...
  13. piannetta

    Adding only the latest data to existing table

    Hi, I am relatively new to Power Query in Excel, I am really enjoying it though and can't believe I didn't pick up on years ago. Anyway, that aside, I've built a number of spreadsheets with a number of queries within each that automate a lot of my reporting and tracking activities. The queries...
  14. H

    Updating Query

    Hi All I am wondering if you could help. I am running a number of queries on data that I receive on an annual basis however every year I receive the data, h columns re not one over, for example instead of using row S it will now use row T. Is there any way that I can update the queries with...
  15. A

    Importing Queries to Blank DB created "Duplicate Output Alias" Errors

    Hi All, I'm working on upgrades for a DB, and for my updated version I began with a blank DB and imported all the forms, queries and tables. I made a number of changes to the forms, but left the queries and tables alone. In the previous version, v.1.3, all my queries worked fine and were...
  16. P

    Yes/No Data Type Mismatch

    Hi. I have a table with three fields: ID, Full Name, yes/no I then have two queries: One query is using this table to see "yes" and the other is looking for "no". But whenever I attempt to run the queries, it tells me there is a data type mismatch. I am unsure what I am doing wrong!
  17. J

    Dealing with errors when refreshing web queries?

    Hi, I have web queries which fetch table into excel but sometimes the table URLs don't exist... I.e - when the tables have no data yet How can I handle these errors so that if table isn't found or has no data >>> then it's skipped Any help appreciated
  18. S

    Excel Queries

    Hi All, If I have some data (say 1,000 rows & 20 columns) on Sheet1, and some data (say 1500 rows & 12 columns) on Sheet2, how can I make queries ? Thank you in advance
  19. A

    Using Indirect in VBA to Refresh Individual Queries

    Hi All, I need help with a project I'm working on and am not well versed using Visual Basic. I've developed a workbook that draws data from several other workbooks and uses queries to populate the worksheets. It's got 80 queries that can be refreshed as needed, but they don't all change data...
  20. J

    Script to change query parameters

    In my dBase, I have three queries that have a parameter that is coded Like"*TUC*" The dBase is designed to be used by various locations with different location coded. Is there a way to change the query parameter in these three queries via a script?

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
Back
Top