Making a comparison to reach a calculation???

[Leo]

I am using Access 2003.

I am creating a subform [Billing]! that is intended for collecting billing
information. I have the [Start] and [Stop] times for appointments calculated
to provide the amount of [minutes]. I than need these minutes converted to
billable units.

[Stop] – [Start] = [Minutes] need to arrive at [units]

I am attempting to do this by:

I created a table [Patient Billing]! that contains fields for [billable
minutes] and [units] – creating the relationship.

I would like to be able to use that table [Patient Billing]! To calculate the
units billed that appear on the [Billing]! subform.

How do I accomplish this comparison between minutes in to tables to arrive at
the units amount?

 

[JethroUK©]

dont generate new tables - you are just generating 'history' - use existing
tables (current info)

you do calculation in a query (not a table) - it's called a calulated field

you can use any spare field in a query and it goes where the field name
normally goes:

answer: [stop] - [start]

this field can be used just like any other field