how do I create an access report for each vendor in a dbf file?

[Guest]

I am running an old dos program that has a database file of all vendor
transactions
in db4 format. I want to use access to extract a monthly stetement for
invoices owed to each vendor on a monthly basis. My current program does not
produce this report. Please help.

Thanks

Clutch

 

[Joseph Meehan]

I am running an old dos program that has a database file of all vendor
transactions
in db4 format. I want to use access to extract a monthly stetement for
invoices owed to each vendor on a monthly basis. My current program
does not produce this report. Please help.

Thanks

Clutch

This is an easy job for even a medium level Access user. How well do
you know Access. If you are not familiar with Access, what you ask is well
beyond what can be normally handled in a newsgroup situation.

Normally you would import the data to an Access table (likely building
more than one table to normalize the data), then build a report sorted and
grouped on vendors.

Additional considerations can handle paid and unpaid invoices etc.

 

[Larry Daugherty]

What have you done so far in trying to solve your problem?