Hello All
I have a table that's laid out as follows:
I need to generate a report that will consolidate all the guide names and the amount they earned for each trip and add it up.
The report should be grouped by Guide name and will look something like this:
My thinking is that i need run a query that will append Guide1 + Guide2 + Guide3 columns as well as the Guidex_wage columns
I've been unable to find a solution. Please help!