0. I have 2 tables Stuff and Contracts.
1. I have Query that joins 2 tables.
It creates a table where there is added info about contracts only to those stuff members who have open contracts.
The query is like this:
SELECT Stuff.*,
contracts.term,
contracts.date_start...
So, I'm a digital product designer, and not a dev at all. For reasons beyond my control, I have to work with and develop a small handmade hr accounting system based on MS Access. I'm happy to find this community. I hope to get some help here.