Forum Discussion
Failure to Retrieve Unique Values -- Relationship Model
I have two tables that each include expense types. I am trying to retrieve a target value and a budget for each expense type. All my Budgeted Items came in on 11/13. My Actual Items, which come in wh...
Hi bw70316,
What is your desired result? Could you please offer your sample data and post your desired result if possible?
Regards,
Daniel He
I am hoping to retrieve unique values from my vendors on the expense types. I have two tables: Budgeted and Actuals. Only Actuals has Vendor Names and Unique Posting Dates, while the Budget Table has only one Date (11/13/2018), and both have expense types. I want to be able to see the budgeted amount for each Vendor (which is inside expense type) to get an accurate remaining total. I feel like I need to make a direct connection between my budgets and actuals table?
