Find Jobs
Hire Freelancers

Find a Access Database solution

€8-30 EUR

已关闭
已发布超过 3 年前

€8-30 EUR

货到付款
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: 28276559

关于此项目

28提案
远程项目
活跃3 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
28威客以平均价€23 EUR来参与此工作竞价
用户头像
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 在1天之内
5.0 (306条评论)
8.0
8.0
用户头像
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 在1天之内
4.9 (240条评论)
7.1
7.1
用户头像
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 在2天之内
4.9 (181条评论)
6.8
6.8
用户头像
I'm expert in SQL, can you let me know more about your query? best regards Bryar.....................
€8 EUR 在1天之内
5.0 (72条评论)
6.3
6.3
用户头像
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 在1天之内
5.0 (20条评论)
6.4
6.4
用户头像
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 在1天之内
4.7 (76条评论)
6.5
6.5
用户头像
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 在1天之内
5.0 (70条评论)
5.9
5.9
用户头像
I can develop required query in a most qualitative way. I am highly qualified SQL developer with a long term experience.
€35 EUR 在1天之内
5.0 (55条评论)
5.5
5.5
用户头像
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 在2天之内
5.0 (27条评论)
5.7
5.7
用户头像
SELECT * [Products_Table] WHERE [sell status] = 'open' AND [Stock] = 0 ORDER BY [Category], [ProductName]; That's it That was the question?
€8 EUR 在1天之内
5.0 (5条评论)
4.2
4.2
用户头像
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 在1天之内
5.0 (5条评论)
2.9
2.9
用户头像
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 在1天之内
5.0 (1条评论)
0.4
0.4
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在30天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
Should be straightforward. Can do this in query designer, or in raw SQL. Will need to see the actual file.
€100 EUR 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi! Have solid experience in SQL / Access / VBA. Give me test data and get a solution.
€30 EUR 在1天之内
0.0 (0条评论)
1.4
1.4
用户头像
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 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

SWITZERLAND的国旗
Oberwangen, Switzerland
4.6
20
付款方式已验证
会员自9月 23, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。