Access

[Srinivas]

I want to create a database in access for creating payment voucher of our
suppliers which has only minimum fields
PV NO:


AMOUNT



LESS: DISCOUNT %

LESS: BANK COMMISSION

LESS: RETURNS


PAYABLE AMOUNT

Supplier Name (which should be imported from excel sheet which i have alread
created)
A unique number for Voucher (Same time 5 clients will access from the
server) but there should not be any problem it should take first save first
number

A discount column will be there t
a logic for calculating bank commission in excel this is the logic im using
=IF(CEILING(A1/1000,5)<=25,25,IF(CEILING(A1/1000,5)<=50,50,CEILING(A1/1000,5)))

Can any one help

 

[Wayne-I-M]

This may take you quite a while and will require some learning. It may be an
idea - if you already know how to use excel - to just create a filtered excel
report and use that.

There are many methods for learning access so if you do want to spend the
time (it will be worth it in the end) you could start here.
http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033

Good luck with your project