In Progress

#12; create a sql-query for comparing 2 access-tables.

we have 2 tables with a structure like follows.

there are for each day 96 records (quarterhours)

now we want to compare each of the 96 values in table1 withe the same values in table2 (identic structure).

we need a small analysis for the differences between the tables in %.

The start screen for this query should have a few input possibilities:

- compare for "customerNr" / "counterNr"

- compare day or from date -> to date

- send a statistic to printer

-

Skills: Data Processing, SQL, Visual Basic

See more: tables in data structure, n query, SQL Query, sql data analysis, send query, Data tables, data query, data statistic, create tables sql 2012, access create query, access sql query, sql query access, sql visual basic 2012, query query, data compare access, records screen, compare access, data input screen visual basic, data processing analysis, small sql query, sql analysis, create date, data structure analysis, data input screen, send data printer

About the Employer:
( 48 reviews ) Stadtbergen, Germany

Project ID: #1706547

Awarded to:

winnet21

I have experience in this project, please check PM

$55 USD in 1 day
(20 Reviews)
5.2

11 freelancers are bidding on average $79 for this job

dobreiiita

Hi, Lets do it.

$100 USD in 0 days
(64 Reviews)
5.4
anhouse

Please see pm for details

$100 USD in 3 days
(2 Reviews)
3.6
amalshaban

more details , ready now

$100 USD in 3 days
(0 Reviews)
0.0
neonsolutions12

Dear Hirer, I have gone through the project details. I am really interested in doing this job. Thank you

$66 USD in 2 days
(0 Reviews)
0.0
saifmit2

My objective is great customer service with broad experience and affordable Implementation. My Notion: "No Satisfaction, No Payment".

$45 USD in 2 days
(0 Reviews)
0.0
anujgupta872003

I have also created similar applications in my other projects. I can do this work in best possible way any performance wise also it would be fast. I have all the skills which are required. In work in MNC so i know wha More

$90 USD in 4 days
(0 Reviews)
0.0
leosrs

Hi I am currently a Data Warehouse developer. In my job we always have to compare tables, I mean compare the transactional table with the data warehouse table to make sure that everything was loaded. Compare DEV with P More

$80 USD in 2 days
(0 Reviews)
0.0
mamama777

Check your inbox for details

$100 USD in 0 days
(0 Reviews)
0.0
vfpapi

Sql & vb Expert is here. Please have a look on PMB.

$70 USD in 1 day
(0 Reviews)
0.0
michaeln78

Sounds like a simple query...Would be happy to assist you !

$65 USD in 3 days
(0 Reviews)
0.0