Batanu, here is what my tables look like if that helps.
I have tried using reports as you have suggested but what comes up is a report that looks like the sales table with the subdatasheet expanded. How do I make the subreport into a column (and how to sum up the total expense per job?)
I've created a very simple database with 2 tables.
One is called sales which has an autonumber primary key and each entry corresponds to a job which has a total value, customer details etc. The other table is called expenses and also has a autonumber as a primary key. Again each entry...