Integrating Excel and Access

Services and Charges

How you build this form really depends on how you build the billing form. It is probably best to have a master bill record with a billing ID, customer ID, and date, along with a subform that holds each item, quantity, and default price. Also, have a field to override the price, to meet the requirements requested by the client. If you have that setup on the billing records, the services and charges table is relatively simple. For each type of service provided, have an ID field, the name of the service, the general ledger account that this revenue is booked to, and a default price.