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...

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...

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...

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*...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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!

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

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

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...

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?