Hey!.
I have Table containing field for a Invoice entry.
Invoice No-----Service--Amount--Aucknow.---Creditdays---Duedays--Due30days--Due60days
I enter a invoice with all details.
I need vba code or SQL statement to calculate how many days that particular Invoice is due from Aucknowledgement Date. And to show in the respectives field.
For example if it is due morethan 30 days, it should show in the filed "Due30Days".
I tried as far as I can. But I couldn't.
Can anyone please help me?
Thanks & Regards
Charles
Last edited by ebin charles; 10-31-2011 at 07:31 AM.
Could you give an example of some records? Which fields are you looking to have filled in, and with what data? Will all the fields be filled in by the user?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
I attached the file.Originally Posted by davegugg
I have three fields. Income, Expense and Net Amount.
I need the net Amount automatically when I enter Income and Expenses.
Thanks in advance.
Regards
Charles
I'm confused, this seems totally different from your initial request. Is Net Amount = Income - Expense? If so, it is generally wasteful to store records in a database that are simply calculations based on other records - it's better to do the calculations in the code.
Regardless, I'd need to see your current form/code to see what triggers the input of data into your database, your tables/form names, etc.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks