AnsweredAssumed Answered

What Relationship Must Be Established to Get Totals from Two Tables?

Question asked by fmpuser0 on Oct 21, 2017
Latest reply on Oct 21, 2017 by fmpuser0

I have the following:


Table 1 – Expenses


Field A: Date

Field B: Concept

Field C: Amount


Table 2 – Flight Time


Field D: Date

Field E: Flight Time (in hours)


I need a report that will give me the expense cost per hour, i.e. the total of Field C divided by the total of Field E.


Table 1 and Table 2 are not related. What relationship must I establish between them to obtain my desired result?


If establishing a relationship between the tables is not the answer, how else can I achieve the figure I need?