11 questions
2
votes
1
answer
69
views
Merging Count Distinct and Group By Range in MS Access SQL?
So, I've got a table with data and their respective acqusition time (in hour:minutes format) on it.
What I want to do with it is:
Count the distinctive values
Display the number of distinctive values ...
- 23
0
votes
1
answer
126
views
Is there a way to 'normalise' my data as it currently is?
We have an Access database that we use for test sample submissions. We have 18 different method we can run, and each method typically has a different number of test runs associated with them (although ...
- 45
-1
votes
1
answer
127
views
How can I display the Query name as a column when I actually run the query?
I run a bunch of queries that check for inconsistencies in our data set. I literally have hundreds of these queries and when one of them has a result I forward it as an excel file to the appropriate ...
1
vote
2
answers
340
views
Excel VBA QueryTable.Commandtext - Select * from [Variable] - (Access Database)
I'm trying to pull Access Queries based on certain input values.
Pulling the correct query works, but it gets stuck on the marked position, because it wont accept a variable and just writes it out as ...
- 15
0
votes
0
answers
33
views
Access Query - update fields by year
I'm tasked with revamping a process to use Access instead of Excel due to the volume of data involved. This process has 4 years of data; 2021 - 2023 are completed and no changes will be made to these ...
- 940
0
votes
2
answers
74
views
Access query: compare records in a group then select one based on a criteria in another field
I've an Access query as shown below & I want to generate the yellow highlighted fields
Description:
For ItemID there are group(s) and a single duration, for each group there are days before and ...
- 133
1
vote
1
answer
81
views
In Access query how to check if a group of records has the same value
In the following query for each group of "first", I want to check if the Values on field "Second" are true.
For example, in the "first" field for "A" Group if ...
- 133
0
votes
1
answer
64
views
Issue with Criteria within access query
I'm trying to write a query that when run will check if a record is overdue by at least 10 days, and if so display it, if not don't. However I am encountering issues with the criteria field for one of ...
- 45
0
votes
0
answers
75
views
Having trouble with MS Access percentile query
I have a MS Access table with a Category field and DollarAmount field.
I'm trying to query the table where it groups the data by Category and then shows the 10th percentile of the DollarAmount for ...
- 53
0
votes
2
answers
253
views
Preventive Maintenance Access SQL Query
I have a problem in MS Access. I wanted have a table, which contains all the maintenance of my fleet. The relevant columns are id_plate, type_of_maintenance, and date. And here is the tricky part. ...
- 1
-1
votes
1
answer
124
views
Get the latest values in each column in MS Access
Please consider this table in MS Access:
Id Year Month F1 F2 F3 F4
----------------------------------------------------------------------
1 2020 ...
- 13.1k