I have a query that inserts data from another table, into an empty table (the table is cleared once a day, and new data is put in once a day). Currently it looks like this: INSERT INTO new (…
Tag: ms-access
how to get a record based on max date for each user in different multiple tables
I’m trying to make a query that can select the names, DateOfSpecimenResult,SwabResult,DateOfReleaseOfResult. Heres the Visual Representation: Table: ContactTracingHeader Table: Swab Note: ContactTracingHeader.AutoID = Swab.PatientNo Table: SwabResult Query Output that I’m trying to make Note: Swab…
Calculating avg time of activity in the morning
I am creating a query to keep track of students’ activity at school on MS Acces 2010. And I have a table as follows: My current attempt on getting the duration But I am not sure how to write the #(= 3Hours / Total number of AM per person per day) part in SQL. Any help is appreciated. Answer Try
Subquery sorted by another table
This is a follow-up question to Get the following record in query. But the task is a bit more complicated. I tried to modify the SQL query but I was not able to fulfill the task. If we have two tables,…
How to sort an SQL table according to an average value in another table
Image of table relationships and fields I am having great difficulty making a query where I want to sort my query according to an average in another table. I have a tblHotels table with a HotelID, …
Excel VBA – ADO Connection to MS Access DB – Filtering results
I have a MS Access Database where I store some information of products and I have these fields: ID, Customer Part No., Description, Price, Observations I also have an Excel file where I have a column called Customer Part No. and in this column I paste the Customer’s Part I want to filter. I need a way t…
MSAccess subdatasheet
I have an Access query, listing invoices and related items in subdatasheet: The problem, that invoices without items not shown: How can I manage to display all the rows from OutgoingInvoice (even if they do not have joined subitem) Answer
Is there any issue to run multi join in access db
I am trying to run this sql statement in access and found Syntax error Select * from TableC C INNER JOIN TableE E on E.TKey = C.TKey INNER JOIN TableP P on P.TKey = E.TKey AND E.employee_id = ‘123’…
Data Joining of two Tables MS Access SQL
I have two tables named – 1) Students 2) Classes. ClassID is Primary Key of Classes table and Foreign Key of Students Table. I want to access one row from the Students table having specfic RollNo (This RollNo is given by user input) and all rows from Classes Table. Students Table is given as:- RollNo is…
How can I avoid duplicates accross multiple columns in access?
My question is pretty simple, yet I am unable to find the answer I need. I have an access database with a table called coaches. I have another table called teams, which can have a coach and assistant coach. I need to be able to allow no duplicates across the “Coach” and “Assistant Coach̶…