How do I create an account ledger for multiple people?

  • Thread starter Thread starter Klingrap
  • Start date Start date
K

Klingrap

I am trying to create an account ledger (a record of fees and payments) for
multiple clients.

I believe I have created the tables and defined the relationships correctly.
The information is as follows:

Table: tblClients
Fields: ClientID, ClientLastName, ClientFistName. . . .

Table: tblClientBilling
Fields: BillingID, ClientID, BillingDate, BillingAmount, BillingType

I have defined a one-to-many relationship between the tables tbleClients and
tblClientBilling using the ClientID.

I want to create form that shows a list of billing transactions for an
individual client and the total amount owing. I also want the form to have a
"data entry" section to allow a user to add additional entries.

I'm stuck. I'm not sure how to define my querry, or how to set up the
subforms, to accomplish my goal. Someone please help.
 
This sounds a little like what you would do with a commercial product like
Quickbooks.

Is there a reason you are developing an Access application from scratch to
do this?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top