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” “Tec…
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 …
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…
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.