Access Queries and Bulk Linking Tables
$15-25 USD / tunti
Hello,
I have a fairly simple database used for converting inbound orders from our clients into outbound orders for our sellers. Sellers each have their own format requirements. I estimate this work to be about 5 hours but in truth I dont know exactly what is required. Most of this is very elementary for an experienced SQL coder.
1: New Query to identify duplicate orders before processing. We receive thousands of orders at a time and errors are made. I need to catch them before we forward them on.
2. Existing Outstanding Order query has 2 fields: Requester and Requester ID. In the query we prefer to have the Requester field but when none is available I need it to fill in the Requester ID in that same spot.
3. New Query that will find duplicates, triplicates, quadruplicates, etc. based on 4 fields. Each of the orders had a request date. Everything except the most recent to be marked as canceled.
4. Existing query for a particular seller requires that requires multiple line items combined into as few lines as possible. So for instance my table will have a line item to order CHERRIES, another line item to order APPLES, and a third to order GRAPES. Their query has columns for BANANAS, APPLES, CHERRIES, and GRAPES and needs a value of "YES" in each of the corresponding fields.
5. Bulk linking files. I'd like to be able to link the first (or only if need be) sheet in a group of excel workbooks to the database. Default name of the linked table should be the sheet name. they always have a header row.
6. Bulk run queries. I'd like to be able to run certain queries in a batch. The macro, SQL, app, whatever, needs to run a query, export to excel, update two date fields with the current date or a date that I enter, then move on to the next query in the batch. Order of operations is essential.
There are 3 very similar databases. Each will need the same thing. Most of the query design from the first one can be reused on the second two with some adjustments. Access to the second and third databases will only be granted after successful completion of the first one.
I look forward to your quote. I cant promise that I have a ton of future work but I do stick with one coder so long as they remain available and deliver quality work.
Thank you,
Seth
Projektin tunnus: #5978146
Tietoa projektista
36 freelanceria on tarjonnut keskimäärin $21/tunti tähän työhön
Kindly ignore the bid amount & time-line, it is just a placeholder to submit the proposal & to start the dialogue, as we still need to finalize few things before giving you our final estimated Man-Hours -------- Dear Lisää
Dear Sir/Madam I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. I Lisää
I have 15 years exp in creating custom Access Databases. I have completed well over 250 of them in this time. I can create a home dashboard to maneuver through your forma and reports with ease I can also create the for Lisää
Hi, Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010 projects both big and small using MS Access as a front end as well as back end. I Lisää
Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Lisää
Hello sir, I am very interested in your project and offer my services. I have experience and ability to get this job done. Looking forward Nblsoft
I am willing to discuss further about the project details and deliver the same to your specifications and needs
Hi Seth, I have read your requirement, can we discuss more in chat? Can you give some examples? Thanks, Samuel
experienced software professional with 20 years in design, development and maintenance of applications. Good with Access development
I am well qualified .NET Desktop and Web Developer. I am experienced in VBA for MS Excel, MS Word MS Access and Facebook Custom Tab Development I have a strong skill set and foundation in ASP.NET, VB.NET, CSS and C# Lisää
I believe I can do the job right. I am an expert in queries, I am confident that I can do it right. a
Let's discuss with me. I have many years of experience working in MS SQL Server, ASP.NET C#, etc. Please let me know so I can start. Thanks...