I am new to access and have been stuck for days on a report. What I have is a table with the following (7) columns:
Job#:SlabBudget:SlabPaid:RoughBudget:RoughPaid:TrimBudget:TrimPaid
I Have a query that adds (3) columns to show difference between each phase budget vs paid
My question is how do I make a report that I can print out that looks like:
Job#
Budget Paid Difference
Slab
Rough
Trim
Totals
Basically a report that has the job# as a header with budget, paid, difference columns and each phase with total on seperate rows underneath.
I hope this makes since. Thanks in advance for any help on this.
Job#:SlabBudget:SlabPaid:RoughBudget:RoughPaid:TrimBudget:TrimPaid
I Have a query that adds (3) columns to show difference between each phase budget vs paid
My question is how do I make a report that I can print out that looks like:
Job#
Budget Paid Difference
Slab
Rough
Trim
Totals
Basically a report that has the job# as a header with budget, paid, difference columns and each phase with total on seperate rows underneath.
I hope this makes since. Thanks in advance for any help on this.