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?
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?
