Accounting question

[garys081]

Hi all,



1st post !

I have a simple database used for invoicing.
I need to split up my invoice total into labour costs and material costs which ive done with separate labour and material fields.

Sometimes I Quote work and the total wont have labour and materials only a total.
But i cant show labour and materials on the invoice to the client as that defeats purpose of a quoted job.

How should i approach this ?

Thanks
Gary

[ranman256]

The queries should pull at least ,
the client key,
the source :labor,or material, or other
the amt. sum or detail.

once you have those you can combine them in 1 query a Union query.

or on a report ,put in Sub reports, 1 for each qry mentioned above.

[Micron]

Possibly:
- allow nulls in the 2 fields and add a field to your table where you only enter full price on no labor/no material jobs. Jobs with labor/materials are summed on the form as usual and the full price field should be Null for those job records. You would need an additional textbox on your form to show the stored cost from this additional field. If labor/material fields are null, disable or hide your existing calculated field. Or are you storing the full price already (which you should not be doing)?

[mike60smart]

Hi Gary

Welcome to the Forum.

Can you upload a copy of your database?