ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do I set up a customer list to track payments (https://www.excelbanter.com/new-users-excel/65273-how-do-i-set-up-customer-list-track-payments.html)

pat

how do I set up a customer list to track payments
 
I have a small service business I have them listed in access - but would like
to track payments and credits for about 200 customers - in a simplified
format in excel


Kassie

how do I set up a customer list to track payments
 
Hi pat

Since you already have the info in Access, would it not be easier to design
a query and report in Access to take care of that? You select the format,
you decide what info you require, you decide how you want it presented.

"pat" wrote:

I have a small service business I have them listed in access - but would like
to track payments and credits for about 200 customers - in a simplified
format in excel



All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com