Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
7 years ago
Solved

Compare in one table from two different queries

Hi,   I need to compare 2 queries: one called FORECAST and other ACTUAL. These 2 queries have same format data with : resources, hours, Payroll, Date data.   The problem is that sometimes in one ...
Need Help
  • JoyCornerstone's avatar
    JoyCornerstone
    7 years ago

    cristianmlhave you tried creating a relationship between the Forecast and Actual table?  If so, which way is it going?  

     

    Another option might be to create a "Resource" table with the names listed and join both tables to that. Then use that name as the item on your grid.

cristianml's avatar
cristianml
Post Prodigy
7 years ago

Hi, 

 

Yes it worked !. I appended both names tables leaving relationships as the attached photo. :).  Now I have to add another just for category and done.  

 

Thanks for your help ! :)

 

Regards