173 questions
0
votes
1
answer
25
views
Add query results straight to form instead of a new table and in a set format
I have successfully created a query, the outcome of the query is to create a unique id in the database, and am able to run it as an embedded macro.
The outcome of the query is each row appears as 'ID ...
0
votes
1
answer
1k
views
Locate and/or reinstall link to MS Query in Excel 365
I have a small data querying and analysis team that uses Microsoft Query to pull data from an ODBC connection. We are running Microsoft 365 and tapping into data sources inside Excel. The ODBC data ...
- 13
0
votes
0
answers
30
views
merging two queries to one query results in some records being dropped
I have two queries that are laid out as follows:
Query name - week1
SELECT
BERTHAGE.BOAT, BERTHAGE.LOCATION, BERTHAGE.BERTH_WEEK, BERTHAGE.BERTH_YEAR
FROM
BERTHAGE
WHERE
(((BERTHAGE....
- 55
1
vote
1
answer
463
views
Query without Locking in MS Access
I have various csv files that export daily with raw data. I link these files into an access database and then have select queries that connect spreadsheet dashboards to the database. Several users ...
0
votes
0
answers
423
views
Microsoft query in Excel returning a blank column when SSMS does not
I'm using MS query to return data to Excel from SSMS.
When I run the query in SSMS it runs without error and all fields return with records (see bottom left).
When I run the query in MS Query (to pull ...
- 317
0
votes
0
answers
49
views
MS Access, passing the total of all outstanding loans to a query to find the percentage of loans outstanding to the total loans for each record
I am fairly new to MS Access so I'll share all pictures and share what I have come up with so far.
I have records of sales agents with loans sold and outstanding loans balances. I want to be able to ...
0
votes
1
answer
44
views
Count columns that ends with the same value starting with a value you choose
I have a table which is like:
Identfier
Abc XY: a(123)
Abcd XY: a(123)
Abcde XY: b(123)
dfe XY: b(123)
dfeg XY: b(123)
dfegh XY: c(123)
ijk XY: c(123)
I want to count columns
that they end with the ...
1
vote
3
answers
892
views
Excel create multiple MS Queries using one data connection between two sheets in the same workbook
In Excel 2021, what exactly is a "data connection", "query" and "domain source name"?
Let's say I have a Workbook "Manahil_Customer_Database.xlsm" in which I ...
- 6,782
0
votes
1
answer
359
views
Query to filter a table where a field can be a number or left empty
I created a form with 3 textboxes & a search button. Also a query that is setup to take the criteria in the textboxes & filter the results of a table with 1000+ records.
I followed this ...
- 65
0
votes
0
answers
729
views
Execute/run a select query in the background, not visible
I would like to find out how to run a select query but have it run in the background and not be seen. I have a "Master Table" with 2000+ records in it, the query I made acts like a filter, ...
- 65
0
votes
1
answer
64
views
Two Table columns into one Query
I'm trying to bring data from two different columns into one query field. Example: Table1 [Field1] and [Field2]. I don't know if that's possible but in my Query I'm trying to bring the datas from ...
- 17
0
votes
2
answers
342
views
Excel data type issues
I am using MS query to pull data from sql server and all is good.
Problem starts when data comes from the server I am stuck with data type general for everything, and no way to change the data type in ...
- 27
0
votes
1
answer
395
views
Why am I getting a "type mismatch" error in my Accessdb query?
I am running a query in Access Database that should aggregate information based on year, month, and type. I set it up so that for the month, it would read the MonthName(InfoDate,1) to return the ...
- 33
1
vote
2
answers
150
views
Using SQL & VBA in MS ACCESS to run a query
I need the correct syntax (with all the quotation marks) for Me.frmButtons.Form.Button01.caption in the SQL-string.
This one doesn't work:
Private Sub Button01_Click()
Dim strsql As ...
- 253
0
votes
2
answers
1k
views
Excel-VBA-Query Is there a way to improve Excel VBA speed with a Refresh.All with a lot of query?
I have a tab and few pivot table. Everything was working fine but now because I added vlookup in the tab along with few formula it make the file VERY slow.
Please note that I have a connection to ODBC ...
- 1