I have 5 tables which I am trying to use the association model with by taking and ID and concat with a date but the association seems to not pulling the data I need (note I am able to do this in SQL using the same method). Can someone help with this I am sure it’s a quick fix and I am trying not rely on SQL to do this.
The Date field has time and date and I have been using:
ID & Date(ArrivalDate, 'M/d/YYYY')
I have also tried with floor (date(ArrivalDate, 'M/d/YYYY')
Table 1 Links to Table 2, Table 2 Links to Table 3, Table 3 Links to Table 4, Table 4 Links to Table 5.
There are no other links between these tables. But my view I want to sum the dollar amount from table 1 minus expense from table 5.
