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 : i need help vb net, import csv data microsoft access database vb net, need best price, help need work designer illustrator, help need design creative brochure, website kindness mission help need template, help need change face picture, microsoft locstudio help, help need artist design, help need marketing help, access microsoft exchange java

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #8461109

28 freelance font une offre moyenne de $86 pour ce travail


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
(74 Commentaires)

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
(34 Commentaires)

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
(99 Commentaires)

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
(38 Commentaires)

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
(36 Commentaires)

A proposal has not yet been provided

39 $ USD en 3 jours
(31 Commentaires)

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)

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
(31 Commentaires)

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
(24 Commentaires)

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
(37 Commentaires)

"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
(10 Commentaires)

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)

A proposal has not yet been provided

72 $ USD en 3 jours
(5 Commentaires)

Hello I'm Microsoft Certified Database Developer. My Microsoft transcript you can check on this link: [url removed, login to view] I have 20+ years experience with Access and 15+ with Plus

45 $ USD en 1 jour
(5 Commentaires)

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)

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Plus

94 $ USD en 3 jours
(4 Commentaires)

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)

A proposal has not yet been provided

73 $ USD en 3 jours
(3 Commentaires)

Hello! I can help in this project! I have the 16 years of experience in the field of automation of the financial sector and trading companies. I am an expert in the field of databases: MS Access; SQL Server 2000-20 Plus

72 $ USD en 1 jour
(3 Commentaires)

Hello, I have 2.5 years experience in vb,vba and vb.net development. I have worked with VB6.0 as Front-end VBA Script EXCEL VBA MS Access as Back-end (.mdb) FoxPro DBF as Back-end (.dbf) Crystal Reports Also W Plus

80 $ USD en 2 jours
(1 Commentaire)