I have created myself a database to track my Estimates, Jobs, Leads, Invoices and such for my Home Remodeling business. It's been a while since I've worked in Access so I am having a bit of trouble remembering the best way to go about generating a report - Invoice.
Basically, I have four different job costs (tblJC_JobCosts) that will be printed on the invoice in separate sections. The issue is that these different job costs don't necessarily utilize all the same fields. For instance, Labor and Materials. Both use the Item field, both use Quantity, but Materials has an associated cost and Labor is calculated differently. Labor also has a Step Number associated with it, but that doesn't exist under any other cost type.
As it stands, I have these in one table. If I try to break them out and join them back up to get into a single record, well you can imagine that each Invoice can have several materials and labor steps. Grouping on the CostType doesn't really seem to work because it displays all four costs similarly, and they really need to be broken out differently.
So basically, I need to have some way of having four different sections with detail on the report, and I can't remember how to get there or even what to search for.
Thanks in advance!
Basically, I have four different job costs (tblJC_JobCosts) that will be printed on the invoice in separate sections. The issue is that these different job costs don't necessarily utilize all the same fields. For instance, Labor and Materials. Both use the Item field, both use Quantity, but Materials has an associated cost and Labor is calculated differently. Labor also has a Step Number associated with it, but that doesn't exist under any other cost type.
As it stands, I have these in one table. If I try to break them out and join them back up to get into a single record, well you can imagine that each Invoice can have several materials and labor steps. Grouping on the CostType doesn't really seem to work because it displays all four costs similarly, and they really need to be broken out differently.
So basically, I need to have some way of having four different sections with detail on the report, and I can't remember how to get there or even what to search for.
Thanks in advance!
