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: – DiameterMeas…
Tag: ms-access
In access/SQL how do I make only the null values in a column equal to value in another column?
I want to make only the blank cells in ATTRIB_VALUE equal to the values in ATTRIB_VALUE_NUM_9. Answer Something like this: I’m not sure what your table name is based on your post, but I think that’ll get you what you need.
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 Acce…
Access number identical fields with decimal number
I have a Table in Access and some field values are identical. If the field values are identical I want to have them numbered with decimal numbers. Is there a way to do this with SQL? Below is an example of my table and what I want to do. Answer You can use a query having two subqueries: Output:
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 Ho…
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 …
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…
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 da…
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
Running Dlookup() on a query with row count column as criteria (MS access)
Im trying to run Dlookup to return all values of a column in a query’s results. As Dlookup can only return 1 result I have added a row count column to the query so I can use the row count as the criteria for the Dlookup. My query results look like this in the results Query design view Query results