Q. Calculate a column to be included in form and report ?

[Jim Jones]

Hi,

Basically, I've been creating this database for an auto service
person.

I'm working on the billing section. I have service details ready,
which records qty, price, extension, service performed and labor cost
to a table.

I'm at a loss, trying to figure out how to continue.

This is what I want to do:

There may be as many as 15 line items in service details.
Half may be on parts ordered for the job, and hafl may be for the
actual labor (let's say installing that part). ok.

So, I need to:

Add the cost of all the labor actions to the cost of all the parts.

Then, add 1% to that sum, for misc.

Finally, add 5% tax to the whole thing.

BUT ! To be able to not charge the customer that 1% misc, at the
mechanic's discretion.

I want to do this all via a query well call qryBilling.

But do I put the calculations in the query grids heading rows?

Is there a better way? Should I do all the calculations int he report
design?

Please help what way would be best .

Thanks,
Jim

 

[Kevin]

I think you have to break this up into a couple of steps.
Do some calculations, with a query and final bill with a
report.

Your table(s) are your data source. Your query should
return all the lines you would see within a particular
invoice detail for a work order. The report should add
the various calculations from the query together a produce
a summary invoice.

Hope that helps.

 

[Jim Jones]

Yes,

That's precisely what I want to do (along with calculating tax, etc.)

Should the tax formula be in an unbound field, in the report?

Also, which Sum function do I use for the invoice detail?

I see this DSum mentioned, but is it the one I use?
Please explain.

Thanks for you help,
Jim