format

[Howard Brody]

You should be able to do it all in Access with two related
tables and one data-entry form.

Table: tblVendors, containing VendorID and all related
information for each vendor

Table: tblLedger, containing the date, VendorID and all
the other data you track on your ledger sheet.

Build a Relationship between the tables, on the VendorID
field.

The good part about Access is you can set the date
parameters on your queries and reports so you can enter
whatever range you need...which means you can use the same
report for daily, weekly, monthly, quarterly or annual
numbers.

Hope this helps!

Howard Brody