I have the following table I am able to retrieve val by group with : Which give me the following output : But I don’t know how to do : Numerical example : How should I do ? Answer
Tag: ms-access
Compering number to a current month in MS Access
I have a data table that looks like this: Id Month Number e1 9 2 e2 10 3 e3 10 1 e4 9 3 The month column is an integer. I want to get a sum of number both for October and September, but by using a reference to a current month and last month, as if the data is
How can I optimize/modify this SQL query to have the same results but with better performance?
This SQL query takes time to execute and I don’t know how can I optimize it/or modify it to have the same results with better performance Answer I rewrote my query like this and it’s very fast Correct me, if I am wrong
Combine cells in access separated by comma
I am new to access and coding. I have a sheet comprising of huge data. I want some specified data in Access by running a query or VBA. What I want is to combine the data based on a column and each data separated by a comma. I am pasting the example of the sheet below: Input sheet Output data
Difference of values in the same column ms access sql (mdb)
I have a table which contains two column with values that are not unique, those values are generated automatically and I have no way to do anything about it, cannot edit the table, db nor make custom functions. With that in mind I’ve solved this problem in sql server, but it contains some functions that does not exist in ms-access.
Syntax issue with UPDATE query using WHERE and LIKE
I am trying to update an empty field in my table to show “Spray Guns Service Kit” if the product code field has “ASPASK” in it. This is what I have tried thus far: Access keeps telling me I am updating 0 rows when I should be updating 100s. However, when I change the code to it works but only
Split data in one column and convert them into column headers in MS Access
I’m trying to convert a column of data into headers on a new table. This question has a good answer but the SQL doesn’t work in Access, I get a syntax error on the very first part of the SELECT statement. Here’s the code, with example names: Should this code work or is it not compatible with Access? How would
Find the names of the suppliers who supply all the parts in MS Access
I have three tables: I want to find the names of the suppliers who supply all the parts in MS Access. This code does not work properly: What could be done better? Answer You need a CROSS join of Suppliers and Parts and a LEFT join to SPB. Then you group by supplier and set the condition in the HAVING
MS Access: Why is my error message appearing immediately after entry?
I have created a form where I enter in faculty information and I made error messages appear if certain fields are missing. However, as soon as I click save, the form saves the entry like I wanted, but also immediately generates the error messages I created, even though I didn’t have a chance to enter anything new into the fields.
Generate numbers 1 to 1000000 in MS Access using SQL
I am looking for a simple clean method to obtain the sequence {1, 2, 3, 4, 5, 6, 7,…,1000000} in MS Access SQL. I thought of creating a table with a column that numbers from 1 to 100000 however, this is inefficient. Is there a way of generating numbers 1 to 10000000 in MS Access using SQL? I tried the