Calculate no of days due in Access Table Field.

**ebin charles** · 10-31-2011, 07:28 AM

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

**davegugg** · 10-31-2011, 10:36 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?

**ebin charles** · 11-01-2011, 11:16 AM

Originally Posted by davegugg

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?

I attached the file.
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

**davegugg** · 11-01-2011, 12:27 PM

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.