I’m working on an Access database for assigning tasks to personnel and tracking task status and workload. A single user ID can be assigned to one of many fields associated with a particular task. In this case, the Task table has fields for “TechReviewerID” “DesignerID” “TechReviewerWorkload” and “DesignerWorkload.” I want one query to return one row for each person, with
Tag: ms-access
Add new column programmatically to DataGridView (DataGridview Filled with DataTable)
I have binded a datagridview with access database table. I want to add a new custom column to DataGridView when the program loads. This column contains the auto incremented number “Serial Number” for the rows in the DataTable. The code is below, But When I run the program the Serial number Column is empty. This column have to show numbers
Access sql Moving Average of Top N With 2 criterias
I have been searching the forum and found a single post that is a little smilair to my problem here: Calculate average for Top n combined with SQL Group By. My situation is: I have a table tblWEIGHT …
How to generate a sequence of ID’s based on mapping tables and values from the forms in MS-Access (Sql)?
I want to generate ID’s based on the form values in MS-Access. And then for each ID generated, create a group of ID’s by adding another 4 digits in the end based on a Mapping Table, representing different octets for different time points (12 ID’s based on the Initial ID and the mapping Table). For example, if the ID generated
How to use UPDATE IIF
I am using SQL in MS-Access. I created some queries that analyze if a code is present in two different excel spreadsheets and generate a new table, informing “yes” or “no” for each comparison. …
Query build to find records where all of a series of records have a value
Let me explain a little bit about what I am trying to do because I dont even know the vocab to use to ask. I have an Access 2016 database that records staff QA data. When a staff member misses a QA we assign a job aid that explains the process and they can optionally send back a worksheet showing
Arranging Columns in Microsoft Access
I am using Microsoft Access to generate a report, but I’m encountering difficulty in figuring out how to have the information displayed in way that will comply to my preference. Specifically: the …
INSERT INTO SELECT with CURRENT_TIMESTAMP value
I have a query that takes all data from database A and inserts it into database B. It is working correctly, however I created a new column in database B called “actual_date” and I would like that, …
VB.NET SQL statement doesn’t return any rows form Access database
I have the following code for a login winform. When I make the connection to the database and make a select statement I get no rows back. I’m getting the message “No data exists for the row/column.” …
SQL query put nth match in new column
I am using SQL in Microsoft access. The table may contain more than one value for a bar code. I want to a query that returns one row with each unique bar code and columns for each of the first 5 values. Right now, I have a query returning the last value or the first value with min or max.