Find Jobs
Hire Freelancers

Running Sum in Access Subform

$30-250 USD

已完成
已发布超过 5 年前

$30-250 USD

货到付款
Think of this like a check book register. There is a beginning balance, in this case it is current inventory on hand. I have an subform based on a UNION query that derives it's data from three separate tables. 1. Purchase Orders, 2. Sales Orders and 3. Work Orders. The query/subform shows in date ascending order four fields. Date, Source(text), Qty., and Order#(text). The data tables are ODBC linked SQL dbo tables. Purchase orders show a positive amount because it is a supply. The sales and work orders are calculated in the base queries as negatives, i.e. [Qty]*-1to be subtracted from the beginning balance, as they are demand. I would prefer to have a solution that is fast, so DSum is not to be considered. The Union query filters on a Form!myMainform!myfield to filter for a specific part #. There are three additional data fields that are used for filtering, via criteria in the query, but are not displayed in the results. I am not using the computer that has the application on it at this time so I cannot show a screenshot of the form. I am not sure that is needed, but can be provided if needed for bid [login to view URL] this is attached to company data I would need to create a sample database with false data to use for development. Before I do that I would like to get an idea of the cost.
项目 ID: 17599138

关于此项目

12提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
I have 19 years’ experience in Access and Excel. My expertise is Access and Excel databases and complex spreadsheets. I have taken all classes from 07 to 13 beginner to expert. If you would like to discuss the project further or want samples please don't hesitate to message me. I have screenshot samples on my profile. either way I wish you the best of luck and I hope you get the design you invitation. Have a blessed night.. Donna My passion is building Custom Access Databases. I have built well over 300 custom databases. Some of the databases I have built include; Production, Inventory, Scheduling, time-clock, Book-Keeping, facilities management, and many custom databases I am bidding on your project because I feel my experience and education has prepared me well for it. My strong desire to become one of the best in my field is my motivation to Excel as an Access Developer and I would appreciate the opportunity to put my skills and experience to work for you. Thank you for your time. Donna
$100 USD 在2天之内
4.8 (42条评论)
6.5
6.5
12威客以平均价$178 USD来参与此工作竞价
用户头像
Hello, How are you on weekend ? I saw overview of your requirements and i would like to tell you that i am happy to serve you. Lets have discussion and finish your job. Thanks
$277 USD 在8天之内
5.0 (20条评论)
6.2
6.2
用户头像
Hi So anyway for calculate running total, Dsum can be one solution and another via behind modules using ADO/SQL vba coding and u can compare speed of them. Regards, Zura
$250 USD 在3天之内
4.5 (48条评论)
6.1
6.1
用户头像
Hi I am an excel VBA, MS- Access expert and went through your project description. I have done many projects like these with multiple user logins. Each with their own usage rights. I have made point of sale software and stock inventory manager as well. I have following plan for the execution of this project Step 1) Discussion of ideas to be included in the software. I can confirm you whether the ideas are feasible to execute or not Step 2) Once all the ideas are laid down. I will give you the overall structure of the program Step 3) Once the approval of the basic structure is done, Coding will begin Step 4) Testing by me Step 5) Testing by client Step 6) Final bug fixes and submission Hope you find my offer useful and we can start our discussion soon. Waiting to chat with you soon! Thanks Sajid Khan
$200 USD 在7天之内
4.2 (1条评论)
3.6
3.6
用户头像
Hey! I hope you are fine, I can do this work with great efficiency as I've a lot of experience in this field. I would like you to give this opportunity to me I assure you I'll not disappoint you. Thanks in advance dear customer. Yet, I'm a beginner at this freelancing site but not in this field chain :). You support will matters a lot.
$55 USD 在3天之内
4.3 (8条评论)
3.1
3.1
用户头像
I work in a co-working environment so I can complete this project with speed & accuracy. I will done your project in full professional way according to your requirements and my creative ideas. I am doing development from last 5+ years. I can also show my past projects to you in chat So inbox sir I will further Insist you there. Trust me you really appreciate my work mark my words sir. kindly share details over chat inbox me.. Your satisfaction is my first priority. i read the description and got it what you want inbox me sir
$155 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have extensive knowledge of Access Forms & Queries and developed many applications. I am sure I can not only help you in this project but also for all your future requirements at a very nominal cost. Excel Automation using VBA and DB Solutions with ACCESS / Excel Training (Basic, Adv & VBA/MACRO) I worked in various engineering companies where i was responsible for processing engineering data generated from various surveys / data extracted from various data modelling softwares eg PDS, STAAD, SP3D etc and converting it into information specially using EXCEL VBA. I can be helpful in providing solutions for your problems using skills a Learned during my job. I have extensively used EXCEL VBA and access database as these does not require any third party software and easy to troubleshoot and assist from remote location. I have developed a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, VB.net, ADO, SQL. i My core competency lies in complete end-end management of a new development project, and I am seeking opportunities to build projects from the ground up for you or your business. I can help in extracting information from ascii files generated from software and generate report in the required format, analysing data, scraping information, etc. Iam also expert in MS ACCESS, VB, VB.net, Powerpoint, PowerBI, VISIO, VISIO Macro, AutoCAD VBA, etc.
$155 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I have very good knowledge on microsoft sql and purchase order and work order.
$166 USD 在4天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Chico, United States
5.0
1
付款方式已验证
会员自8月 18, 2018起

客户认证

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