Firstly I know very little about microsoft access. I know how to create basic queries.
I need to create two queries
One with a criteria which needs to be entered everytime accessed. E.g. Date is variable according what you need to find.
I want to make it so that the user can type in a date that they wish to look for and it will be displayed with all the relationships.
Two
A A query which does calculations similar to excel. Uses data from the first query such as the date entered and calculates new data from it.
E.g. A addition of all results if they were a number in a row.