How do I create an account ledger for multiple people?

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.
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top