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?

Outcomes