Write some Software

Closed Posted 7 years ago Paid on delivery
Closed

I have two MS Access issues I can not solve . . . as follows . . .

> First, I have a situation where I need to write a query (versus VB) to populate null fields in a record based on a previous records populated field above. I think Dlookup in an update query could work but I can not seem to get the query to function properly. As well I will help on additional querys as we move through the project

> Second, I have a .cvs data source file I want to load into access . . . I typically use linked tables for this type of situation. However, in this case, certain fields early in the month have no populated records and thus are not included in the early .cvs data files. For example, I may start the month with 25 fields in week 1, add a field in week two, and then add three more fields in week three, ending the month with 29 fields. Presently we are opening the .csv files in Excel and adding the fields manually . . . NOT AN OPTIMAL SOLUTION . . . I need help in architecting and programing a routine that can seamlessly handle this situation.

Microsoft Access MySQL SQL

Project ID: #11904280

About the project

33 proposals Remote project Active 7 years ago

33 freelancers are bidding on average $52/hour for this job

leadconcept

Dear Sir, I understand the issues, so can you provide us access to the Access database? Look forward to hearing from you & start further discussion thru' private chat. Regards, YK LEADconcept

$55 USD / hour
(48 Reviews)
8.4
technosystem

Project: MS Access Issues Skills: VB, VB.NET, ASP.NET, C#, MSSQL Experience: 11 Years Expertise: Desktop and webapp development Team Size: Dedicated Programmers

$55 USD / hour
(46 Reviews)
8.4
illuminesoft

We are amongst top 1% global outsourcing providers. We have successfully finished over 430 projects in last 13 years. ID : 11904280 Greetings, We are interested to work on this project, please find my comments i More

$50 USD / hour
(330 Reviews)
7.7
branislavm

Hi, This is doable, although using query for the first task is not always the best solution. It may work slow. I can help you with other tasks as well and we can discuss in details how and why. Regards, Brani More

$55 USD / hour
(285 Reviews)
7.6
sumon355

Hello, As an expert in ms access and sql related works, i am very much interested to do this work. I understand your requirements and i can do it efficiently. Looking forward to have a positive response from you. More

$50 USD / hour
(234 Reviews)
7.4
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$50 USD / hour
(133 Reviews)
7.0
VladimirLilenko

Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wit More

$50 USD / hour
(161 Reviews)
6.6
bmartynvw

Hi, My name is Benjamin. I'm a solution architect and Access developer with over a decade of experience. I would love to work with you on resolving this issue. Look forward to hearing from you. Regards,

$50 USD / hour
(17 Reviews)
6.6
shikhamehta

Hello there, I am an expert in Access and have created several databases of different level of complexities. I reviewed the issues you are having with your database and can resolve both of them for you. If you could More

$55 USD / hour
(190 Reviews)
6.4
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$50 USD / hour
(32 Reviews)
6.1
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

$55 USD / hour
(15 Reviews)
6.0
jawadaman

Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines More

$50 USD / hour
(90 Reviews)
5.8
iglobalvn

Hi sir, I can do your project perfectly and exactly without any risk. If you wanna confirm me, please check my work history and portfolio kindly. Then, you can know about my ability that can do your project enough. More

$50 USD / hour
(48 Reviews)
6.5
prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i wi More

$51 USD / hour
(15 Reviews)
6.1
zu02

Hi Here needs vba+sql+ado + mathematic and + intuition (impossible to learn) . I think I am in this range somewhat. Below is a my introduction: I’m an Access/VBA coder, a mathematician and a full time developer More

$55 USD / hour
(48 Reviews)
6.1
jinankthakker

Hello, i have more than 5+ years of exp in different framework of PHP like Laravell, CakePHP, Codeigniter, and Wordpress. I am sure i can do your work with 110% of your satisfaction. In case of emergency i ll be More

$50 USD / hour
(15 Reviews)
4.4
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and More

$50 USD / hour
(9 Reviews)
4.6
Grunty

Hi, I believe I've understood both your issues. It seems like you're trying to do the same thing (populate empty fields with the precedent record's values found for those fields) both in the database and in the csv fi More

$50 USD / hour
(5 Reviews)
4.4
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$55 USD / hour
(32 Reviews)
4.5
sofex

Hi, I have been programming in VBA for more than 15 years and I will be happy to fix the required issues and make the solution as convenient as you need. Please have a look at my portfolio and let me know if you need More

$50 USD / hour
(11 Reviews)
4.2