Database help
Posted: Wed Aug 24, 2005 6:15 am
hi there,
I got some prob here hope you can help out.
Need to create a simple stock management program. Done all great but accounter 2 probs.
1
need to find an easy way to do some calculations like additonning amount in a column. like after having the amount by multiplying QTY*Unitprice in a column called Amount, I want to add all the amount in the column to have the total amount Per order or per invoice for example. Hope you have easy way of doing this.
2
I want to print out. But I can not get a good looking printout eventhough it look great on the computer screen.
Or is there an easy way of exporting the table in excel where i can carry out necessary calculation and print out?
Will appreciate your help.
I got some prob here hope you can help out.
Need to create a simple stock management program. Done all great but accounter 2 probs.
1
need to find an easy way to do some calculations like additonning amount in a column. like after having the amount by multiplying QTY*Unitprice in a column called Amount, I want to add all the amount in the column to have the total amount Per order or per invoice for example. Hope you have easy way of doing this.
2
I want to print out. But I can not get a good looking printout eventhough it look great on the computer screen.
Or is there an easy way of exporting the table in excel where i can carry out necessary calculation and print out?
Will appreciate your help.