Find Jobs
Hire Freelancers

Find a Access Database solution

€8-30 EUR

Cerrado
Publicado hace más de 3 años

€8-30 EUR

Pagado a la entrega
I have an Access Database and I need the SQL code to find a solution: Which of the articles that have to be dispatched (sell status = open) are not on stock , sorted by article category and article name ?
ID del proyecto: 28276559

Información sobre el proyecto

28 propuestas
Proyecto remoto
Activo hace 3 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
28 freelancers están ofertando un promedio de €23 EUR por este trabajo
Avatar del usuario
Hello, As an expert in ms access and writing sql queries, I am very much interested to write the require query to retrieve the required filtered data. Thanks
€26 EUR en 1 día
5,0 (306 comentarios)
8,0
8,0
Avatar del usuario
Hello! I am ready to carry out your project. You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladimir
€20 EUR en 1 día
4,9 (240 comentarios)
7,1
7,1
Avatar del usuario
Hi, I am well versed with MS Access SQL queries and can help to write the query to find the articles to be dispatched. If possible, please share the MS Access file. Keen to work on this project. I have recently completed MS Access based project with good feedback. I am well versed with MS Access VBA. https://www.freelancer.com/projects/microsoft-access/Access-Query-save-CSV-ftp/details https://www.freelancer.com/projects/software-architecture/Access-Data-Base-Creation/details https://www.freelancer.com/projects/microsoft-access/Make-Microsoft-Access-Database-Process/details https://www.freelancer.com/projects/microsoft-access/Access-simple-CMR/details Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010,2013,2019 projects both big and small using MS Access as a front end as well as back end. I have worked on Forms, Queries, Modules, Reports, Sub Reports, Macros, Switch Board Manager, Linked Table Manager etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
€30 EUR en 2 días
4,9 (181 comentarios)
6,8
6,8
Avatar del usuario
I'm expert in SQL, can you let me know more about your query? best regards Bryar.....................
€8 EUR en 1 día
5,0 (72 comentarios)
6,3
6,3
Avatar del usuario
Hi there, I am an experience T-SQL developer with more than 9 years experience. I am able to done any kind of project using this skill. I have done many prj like this and always got 5 starts and positive feedback from my clients. I hope you will assign me this job and I can show you all my best performance to make you satisfied. Thank you so much!
€20 EUR en 1 día
5,0 (20 comentarios)
6,4
6,4
Avatar del usuario
Hello I hope all's well with you. I see you are looking for a developer proficient in Ms Access / VBA. I am an Access / Excel / vba expert from Georgia, full time freelancer. Please visit (where I mostly work): https://www.freelancer.com/u/zu02?w=f I can code SQL in your Access DB - professionally and on time . I hope for your quick feedback. Thanks for your attention and Regards, Zurab
€8 EUR en 1 día
4,7 (76 comentarios)
6,5
6,5
Avatar del usuario
Hello and good day, I believe this is just a simple sql task and I would say that I can finish this project as soon as possible. Feel free to message me so that we can talk more about this. Thanks
€15 EUR en 1 día
5,0 (70 comentarios)
5,9
5,9
Avatar del usuario
I can develop required query in a most qualitative way. I am highly qualified SQL developer with a long term experience.
€35 EUR en 1 día
5,0 (55 comentarios)
5,5
5,5
Avatar del usuario
Hi, I am ready to help you in your access queries, please give me more details about the requirements. I have experience in MS SQL server, asp.net, crystal reports and VB.net more than 13 years. Other skills: Access vba, Excel vba, C#, my sql , technical & Sage 300 (ACCPAC) ERP support, SQL server Replication, Microsoft office(Word, Excel, PowerPoint, Access), Windows servers. Best Regards. Khaled Alflah
€30 EUR en 2 días
5,0 (27 comentarios)
5,7
5,7
Avatar del usuario
SELECT * [Products_Table] WHERE [sell status] = 'open' AND [Stock] = 0 ORDER BY [Category], [ProductName]; That's it That was the question?
€8 EUR en 1 día
5,0 (5 comentarios)
4,2
4,2
Avatar del usuario
I have 7 years of work experience in SQL Server, Access, VBA and macro. I can do your project and complete before time.
€19 EUR en 1 día
5,0 (5 comentarios)
2,9
2,9
Avatar del usuario
Hello There!! This is Dheeraj from India. I have more than 9 years of experience in Database Development, Data Visualization and Administration Experienced in working on Different big products like Yardi Voyager, WMS. TaskTrack My Skillset includes but not limited to:  Writing Stored Procedures, Views, Functions and Queries for the product development and customization  Writing complex queries for report/product development  SSIS. SSRS, SSAS, ETL  Managing the entire database  Monitoring SQL Server Performance and troubleshooting  Power BI | DAX | Excel | Power Query  Installing, Configuring and Administering SQL server.  Performing Database maintenance activities like Backups, Restoring.  As a part of the DBA team providing 24x7 production support to the clients.  Monitoring Scheduled jobs.  Configured log-shipping between the servers.  Monitoring the Disk spaces on all the servers.  Checking the general Health of the servers for identifying Bottlenecks.  Analysing, Identifying and Resolving performance issues of the server.  Database performance tuning for optimal results.  Ensuring High Availability using Technologies like DB mirroring, Log shipping.  Backing and Restoring of Databases.  Scheduling and scripting Jobs. Looking forward to working with you and achieve mutual benefits.
€10 EUR en 1 día
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
Dear Sir, I am an expert in SQL haing an experience of 5 years. I can provide you the solution for the above mentioned scenerio. lets knot the deal. Regards, Ahmad
€19 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I am new to freelance. I have no work experience with databases. I do not have Access, but I can work with MySQL. Here is a possible solution to the query. SELECT dispatched, sell status, article category, article name FROM articles WHERE sell status = 'open' AND sell status = ' not in stock' ORDER BY article category, article name;
€8 EUR en 30 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am expert in transact sql I am expert in transact sql I am expert in transact sql I am expert in transact sql
€9 EUR en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Should be straightforward. Can do this in query designer, or in raw SQL. Will need to see the actual file.
€100 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I need to see the database or talk to you to understand exactly what you want. At the moment You say you have the database but is the development database or a closed database that needs reverse engineering
€30 EUR en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi! Have solid experience in SQL / Access / VBA. Give me test data and get a solution.
€30 EUR en 1 día
0,0 (0 comentarios)
1,4
1,4
Avatar del usuario
Since 2001, I have specialized in designing, developing, upgrading, and maintaining MS Access databases, specializing in MS Access, SQL, Visual Basic. I have developed hundreds of different database applications, both for full-time employers, and as a consultant with an international clientele. I have developed systems for companies such as Cigna, Citizens Bank, Department of Defense, E. & J. Gallo Winery, General Dynamics, Patheon, Pfizer, Raytheon, and Xerox. I have a Masters' degree from Rensselaer, in Management of Information Systems, and have a Microsoft Certification for Microsoft Access 2010. I review existing files and documents without cost or obligation. I can commence immediately, upon receipt of files and/or specifications, and typically provide either recommendations or a prototype for review within 24 hours.
€10 EUR en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Greetings, My name is Thiseas and I am currently working in one of the biggest online Gambling and Casino providers. I mainly work with .NET, MSSQL and Entity Framework. I will be more than happy to assist you in constructing your query and maybe answer a few of your questions regarding SQL if time permits. Thank you for your time and I will be happy to meet you!
€25 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SWITZERLAND
Oberwangen, Switzerland
4,6
20
Forma de pago verificada
Miembro desde sept 23, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.