Access Database Query / Report Creation - Analyze Production Line Start, Stop, and Down times

完了済み 投稿 Feb 15, 2016 着払い
完了済み 着払い

We have 3 production lines. Each time a production line is started or stopped, a 1 (for started) or 0 (for stopped) is recorded to a database along with a time stamp. I would like to create a report that shows me the following information for a specified date range and for each production line. 1) Total Time On. 2) Total Time Off. 3) Total number of stop instances less than 10 minutes and total time stopped for those instances. 4) Total number of stop instances greater than 10 minutes and total time stopped for those instances. The data table this is pulled from contains information from many other processes as well - so it will be important to optimize the queries for efficiency. The data is stored in a mysql database, linked to the Access database via odbc. For development a sample access database with a portion of the data in tables will be provided.

マイクロソフトアクセス SQL

プロジェクトID: #9662090

プロジェクトについて

17個の提案 リモートプロジェクト アクティブ Feb 18, 2016

アワード:

torajiv

Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by go もっと

$111 USD 3日以内
(127レビュー)
6.6

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

branislavm

Hello! I would like to see the actual data. Also, I have one proposition. Let me create SQL and report (and all that it takes) and, if you are happy how it work, you can accept my bid. If you do not like it, no obli もっと

$166 USD 3日以内
(205件のレビュー)
6.5
expertcoder1vw

Hi, I'm an expert Access / VBA / Excel / database programmer and can do the job for you. I can code the queries and user interface to calculate the stats and display them on a form or report. I can deliver in 4 もっと

$250 USD 3日以内
(52件のレビュー)
6.0
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc もっと

$388 USD 7日以内
(9件のレビュー)
4.8
aleator

I am not a mediator. I will help quickly and efficiently. Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the Access, of course, familiar.

$66 USD 1日以内
(23件のレビュー)
3.8
zvrck

Hello sir, I am IT specialist with more than 6 years of experience in website and software development. Please choose me, give me a chance, you will not regret, I promise. You will get the best European quality of work もっと

$55 USD 2日以内
(2件のレビュー)
3.2
SandelaSolutions

Hi - I am an experienced Access developer and run my own small IT agency in Durban, South Africa, where I create and maintain Access systems, which is the core of my business. I have also successfully completed sev もっと

$250 USD 3日以内
(5件のレビュー)
3.2
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ もっと

$30 USD 1日以内
(3件のレビュー)
2.3
umeshrathod1982

Hi, Could you please ping me on chat to discuss the same? We are expert in PHP and .NET so I am sure that I can fulfill your requirements. Expecting your best. Thanking you Umesh

$150 USD 3日以内
(レビュー1件)
1.8
suporteideacorp

Hello, my name is Ramon, I am director of a company called Ideacorp in Brazil. My company has a number of qualified professionals in the following areas: - Development of web sites and applications; - Configuration もっと

$55 USD 3日以内
(2件のレビュー)
0.7
manager2015

Questions: 1. Which Access version you are using at the moment. 2. Please share the sample access database with a portion of the data in tables. 3. How many tables are involved in querying the report?

$315 USD 5日以内
(0件のレビュー)
0.0
AlekseiAdamovich

I'm excellent in Excel, but I'm just starting the career here, so I'll do it for cheap and with high quality.

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

Hi, I work with PHP and HTML5 to make sites and reports from MySQL databases. We can have a working report within a few days with all the data you're after. Thanks, Dan

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

I'm experienced in MS Access report building, including merging data from different tables, macro functions writing, etc. I'll be glad to develop proposed app for our good. -- Igor

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

34 + years experience, successfully deploying database solutions. 23 + years programming with Access. All kinds of solutions, for a wide variety of satisfied clients. Best regards

$222 USD 5日以内
(0件のレビュー)
0.0
dleony

A proposal has not yet been provided

$250 USD 14日以内
(0件のレビュー)
0.0
ttaylor3006

I have a long history of report writing and business programming. I am well versed in Access, SQL and DB2 and will certainly work with you to meet your requirements. I encourage you to communicate with me so we are o もっと

$150 USD 5日以内
(0件のレビュー)
0.0