Running Sum in Access Subform

完了済み 投稿 5年前 着払い
完了済み 着払い

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.

データベースプログラミング マイクロソフトアクセス マイクロソフトSQLサーバー MySQL SQL

プロジェクトID: #17599138

プロジェクトについて

12個の提案 リモートプロジェクト アクティブ 5年前

アワード:

workerbee1974

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 もっと

$100 USD 2日以内
(42レビュー)
6.5

12人のフリーランサーが、平均$178 で、この仕事に入札しています。

khp31

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日以内
(20件のレビュー)
6.2
zu02

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日以内
(48件のレビュー)
6.1
sajidkhan45

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 softwar もっと

$200 USD 7日以内
(レビュー1件)
3.6
nabeelkhalid0

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 もっと

$55 USD 3日以内
(8件のレビュー)
3.1
Awan005

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 fr もっと

$155 USD 3日以内
(0件のレビュー)
0.0
GeoDelhiExcel

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 Automat もっと

$155 USD 3日以内
(0件のレビュー)
0.0
nayanaarewar

I have very good knowledge on microsoft sql and purchase order and work order.

$166 USD 4日以内
(0件のレビュー)
0.0