|
Hi Arest, you got pretty close.
First tell me, in the table Targets, why did you put the data type for month as text?
See the updated file with below changes.
1] Changed Data Type of Month_ in Targets to Number (for this I had to delete the relationship)
2] In the query "This is where the problem..." I removed the table Projects and added the Query "Projects Query"
3] Added a join in Months column of both
|