I have two ACCESS tables as follows CustId CustType 1 Silver 2 Gold 3 Gold xDate CustId Value 01/01/2020 2 100 01/01/2020 1 50 02/02/2020 2 100 03/01/2020 2 …
Tag: ms-access
Microsoft Access “User-defined type not defined”
When trying to run the following code, I’m getting an error when it hits Dim qdf As QueryDef saying User-defined type not defined I think it’s really weird because I have a backup of this same project in which not many changes were made after it which is working completely fine for this. I’ve tried to retrace my steps and
Access – Add Left Join to Return Value Based on Primary Key (PK)
I need help querying a user name based on its primary key value in table. Another user @gordon-linoff helped me create a query to pull the most recent NoteDate for every OpportunityID in a table. I …
convert access group by query to sql server query
I’m unable to convert MS Access query to SQL SERVER Query, with changing the group by columns because it will effect in the final result. The purpose of this query is to calculate the Creditor and …
Modify a query recordset to complete information (MS Access)
im working in a project in Microsoft access to query the date, hour and a quantity of products by line of production. However, I need to display all of the 24 hours of production in a column but cannot do it since I don’t have records for the missing hours. I’m using Totals to sum the quantity of products produced.
How do you update multiple rows in one column in a query?
In my table I have a column called test3 which has 8 rows in it, values ranging from 6 to 9, I am trying to use an UPDATE statement in SQL to update all of the rows in test3 but it doesn’t seem to …
MS-Access: Calculate Stock From 3 Tables
I was reading this post from StackOverFlow to adjust query to calculate stock from 3 tables. I have 3 tables tblItems, tblPurchase and tblSales. tblItems contains items information like below. Screenshots of my tables tblItems: tblPurchase: tblSales: And my expected result like below In query result items details will come from tblItems. Sum purchase quantity per item and sum sales
SQL string in access VBA not behaving as expected
I have a bit of access VBA that for the life of me, I cant work out what is wrong. First off, here is the offending section of code, and I’ll explain what I want and what it’s doing below. …
Calculate sum of duration SQL
I use the following sql to calculate the duration in the first query. CDate(TimeSerial(Val([EndTime])100,Val([EndTime]) Mod 100,0)-TimeSerial(Val([StartTime])100,Val([StartTime]) Mod 100,0))) AS …
Access/SQL: How can I check if in a table all duplicates (same date) have a value of 0 except one?
I have a table in Access (tblExample) which consists of the fields ID, tripID, day and value. This table is edited by a form. When the user closes the form Access should validate the entries made. It is ok to have multiple records of the same date in day. BUT…if there are multiple records of the same date only one