Skip to content
Advertisement

Tag: ms-access

stack or union multiple fields in MS Access

Beginner’s question here… I have a table of tree measurements being 3 fields: – ID, Diameter_1, Diameter_2 & I wish to get to these 3 fields: – ID, DiameterName, DiameterMeasurement Input and Desired Output Though it results in only 2 fields. How may the field: – DiameterMeasurement be brought in? Many thanks 🙂 Answer You were on the right track

SQL query does not work in Excel but works in Access

For the code listed below, it runs fine except for the first SQL query. I’m pulling address and state information from the workbook, and running a query on the information to find the count of how many times the address appears in the table. If I run the code and stop it before the query is sent to Access, I

MS Access Pivoting Query Result Rows into Columns

I’m new to working with MS-Access reports. I have a query that returns the results of employees timesheets, grouped by both month and paycode. I’d like to make a report showing the the following Employee OT Shifts Jan Regular Shifts Jan OT Shifts Feb Regular Shifts Feb 1234 1 1 2 1 5678 5 2 1 0 However my query

Using Variables in a MSAccess Function with SQL

I’m struggling with entering a custom made ID number on all my tables to link all records together, trying out normalization. I have an EmployeeDetails table and a LoginDetails table. Its my understanding that I need a field called EmployeeID on both and I can use the SQL Select code I have to pull the data like on other forms.

Duplicate records in table after left join

I have three tables. “Departments” table: department_name, department_id. Table “LowPrice”: departmend_id, product_name, purchased, sold, price. Table “Basic”: departmend_id, product_name, purchased, sold, price. In the tables “Basic” and “Low” there can be several records pertaining to one department. There is no relations between these tables. I want to develop a query that will group records from the Low and Basic tables

Access SQL Query to display the most recent date only for duplicate records

Below is my current MS Access SQL that displays all records. However, If there is a duplicate account record, it should only display the record with the latest date ComputationPeriodStartingDate Dataset example. All non duplicates should be returned, Account 1005 is the only duplicate of which only the one dated 12/1/2021 should be included in return Account ComputationPeriodStartingDate LastName Categories

Select only the most recent records by record ID

I have an access database, in it, I have a number of records where I need to pull just the latest information . Here’s the code I am trying to get working : The idea here, is I need 1 Training, and I need just the employees who took that training, and only the last time they took it. Currently

Advertisement