Time Cards/Invoice Report

[sparklegrrl]

I am trying to create an invoice report.

I have a table consisting of a combo box to select the job, a combo to select the employee and a column for regular hours and a column for ot hours.

I then created a query by job and it displays all time partaining to that job, the date & employee.

I also have a table for with the combo again for job & employee and a combo for inventory item used and a column to enter the amount used.

I created another query by job and it is also working fine. It displays all the inventory items used by job.

What I want my report to do is include both of these reports as well as look calculate the quanities which means it would have to look up the item costs & employee hourly salary to total it all.

Do I need to somehow include those fields in the tables or queries or can they be added to the report?

I hope all that makes sense?

 

[D.Mair]

Hi

Firstly I think you need to create a report for each query
ie
report1
report2

you then insert each of these using subreports into what will be your main report.
i think you will link them by job!

you can do all the calculations in reports 1 & 2 you would then add the totals in the main report.

ie

=([report1].[Report]![Total]+[report2].[Report]![Total])

Where Total is a text box in report1 with a calculation in it something like

=Sum([time])

I think this is how to do it! However there are lots of cleverer people than me on here.

Hope this helps
Please get back to me if you want more info or this isn’t what you are looking for.

First time on here for a while, been far to busy at work.

David

 

[sparklegrrl]

It helps a BUNCH...thanks, I'll try it out!