Fermé

Need help with VB in microsoft access

I have a table in microsoft access and need to create a report showing straight line depreciation for 6 years with 0 salvage value.

I have started it but need help finishing it.

Fiscal Year: July 1 (7/1) to June 30 (6/30)

The purchase date, purchased price, and fiscal year columns, accumulated depreciation , and net to be depreciated columns will be affect.

Calculate straight line depreciation for 6 years from the current fiscal year.

if the purchased date is not a full year then, for the first year, subtract the unused months. Ex: if purchased in august, then it will be 11 months instead of full year.

The following years will be same, except the last year will show the remaining balance if within the years shown from the current fiscal year.

Otherwise, future amounts will be summed in the "net to be depreciated" column. No need to show future year columns. This report should be 5 years back from the current fiscal year.

"accumulated depreciation" will consist of sum of all the amounts minus any "net to be depreciated amount"

Compétences : Microsoft Access, VB.NET, Visual Basic

Voir plus : need help net, need best price, microsoft locstudio help, help need artist design, access microsoft exchange java

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #8461109

29 freelance ont fait une offre moyenne de 85 $ pour ce travail

wsh2

Summary: Excellent MsAccess(VBA+SQL) programming experience with strong depreciation calculation accounting understanding / knowledge. Greetings from Easton PA.. {smile} Highly experienced (20+ years) MsAccess B Plus

89 $ USD en 3 jours
(27 Commentaires)
5.8
mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. I have worked on several MS Access projects which included VBA coding extensively and thus can provide you efficient so Plus

75 $ USD en 2 jours
(75 Commentaires)
5.8
fabest

Dear, I am Access/VBA expert since 11 years. I can fix your issue today. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

94 $ USD en 1 jour
(30 Commentaires)
5.8
amcsummers

Welcome to Freelancer! There are a lot of good coders out there. Freelancer asks everyone to review the people they work with after every project. This will give you some insight on what to expect from the person you a Plus

94 $ USD en 3 jours
(33 Commentaires)
5.2
mdkass

A proposal has not yet been provided

39 $ USD en 3 jours
(28 Commentaires)
5.0
Ayan

Hello, I am interested in this project. I can start right away and deliver it in a day. Please let me know when you want to discuss further. Thanks.

30 $ USD en 0 jours
(36 Commentaires)
4.5
AlexandrK1

A proposal has not yet been provided

100 $ USD en 3 jours
(15 Commentaires)
4.2
abhinovpankaj

Hello, I have been working as freelancer since last ~ 2.5 years, prior to this was working with a MNC as a Sr. Software Professional. The project is Product based development and integration of the product with v Plus

83 $ USD en 3 jours
(15 Commentaires)
4.5
mantumalakar10

Hello, I would like to work in this project . please contact me , and you can see my portfolio for kind of work that I have done only In freelancer. I also have done other projects outside of freelancer. Thanks, r Plus

72 $ USD en 3 jours
(17 Commentaires)
3.9
kevivu

Dear Sir, Done numerous similar projects in past the and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Plus

100 $ USD en 1 jour
(9 Commentaires)
4.1
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you. I am very muc Plus

77 $ USD en 3 jours
(5 Commentaires)
3.5
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Plus

111 $ USD en 3 jours
(2 Commentaires)
3.5
softtechsurat

Hello sir/madam, we have read and understand your requirement and very much confident that we can complete this project within low budget and less time . Give us chance to serve you better Looking forward to be Plus

263 $ USD en 3 jours
(3 Commentaires)
3.0
bspanovic

Hello I'm Microsoft Certified Database Developer. My Microsoft transcript you can check on this link: http://89.38.210.110/myfiles/MS_Learning_Transcript.pdf I have 20+ years experience with Access and 15+ with Plus

45 $ USD en 1 jour
(3 Commentaires)
2.9
ithuang2014

A proposal has not yet been provided

85 $ USD en 2 jours
(7 Commentaires)
2.8
aleator

I will help quickly and efficiently. The first result within 24 hours! Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the Access, of course, famili Plus

50 $ USD en 1 jour
(8 Commentaires)
2.6
Marknetic

I've been working with Microsoft Access for about three years now and I've developed a lot of applications so far. I can show you some of my previous works if you wish. I'll take a look at the example database you post Plus

78 $ USD en 3 jours
(2 Commentaires)
2.0
decester

A proposal has not yet been provided

72 $ USD en 3 jours
(2 Commentaires)
2.2
logoDS761

A proposal has not yet been provided

73 $ USD en 3 jours
(3 Commentaires)
2.4
SBITServices

"Thanks for looking our proposal!! **Check our reviews to confirm our work quality(100%completion rate) ***From last 4.5 years of we done more than 1200 projects in O-Desk,Freelancer, Guru and E Lancer***We are expert Plus

30 $ USD en 3 jours
(2 Commentaires)
1.3