I have a deadline till Friday and really hope that you could help me. Sorry if I did something wrong..
Problem: I was asked to create a report. I have a table with projects (“projects”) and a table with targets (“targets”). Every project has a date, value and a type (two types). “Targets” has: month, target value and type. The idea is to create a report which shows if the target was achieved for each month. And if there are no projects in one of the months then the report should display “0”.


Table “Projects”
ProjectID, Project name, Customer, Date started, Value, Type
Table “Targets”
TargetID, Month, Target, Type (For example, for April target for funding project was £1000)
The output should look like on the picture attached.
I have no idea if it possible to implement using access (how to connect these 2 tables..). But I was asked to do it in access since the information about all the projects is already there.
Picture description (the act val – value of the project, the target value – value from the targets table).
I will be very happy to hear all the suggestions and advices.
Thank you!