Find Jobs
Hire Freelancers

database in access

$15-20 USD

已完成
已发布将近 15 年前

$15-20 USD

货到付款
I need a simple database with some pre definied queries. See attached excel file for example of data. The basic idea: - there will be a main table with about 8 columns - every week I need to import a new table (same structure as the main table) and compare it with data in the main table. If the record from the new table allready exists in the main table then nothing sould happen. If the record doesn't exist then it should be added to the main table. Third option is that a record from the main table does not exist in the new table anymore. Then the record in the main table should be updated stating that the record is no more present and the date from new table should be indicated in column 9 of the main table. The queries should do the following: - select records from the main table based on criteria for code1 and calculate average code3 for those records. - select records from the main table based on criteria for code1 + code2 and calculate average code3 for those records. - calculate average number of days between indicated date and date in field 8 for all records or records specified by code3 criteria ## Deliverables Have a look at the excel file in the attachment. Sheet 'main' would serve for the table 'main' and sheet 'new' represents how the weekly new file would look like.
项目 ID: 3877905

关于此项目

9提案
远程项目
活跃15 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$12 USD 在3天之内
5.0 (538条评论)
7.2
7.2
9威客以平均价$14 USD来参与此工作竞价
用户头像
See private message.
$17 USD 在3天之内
4.8 (303条评论)
6.4
6.4
用户头像
See private message.
$17 USD 在3天之内
4.9 (86条评论)
5.2
5.2
用户头像
See private message.
$17 USD 在3天之内
4.5 (6条评论)
3.6
3.6
用户头像
See private message.
$11.05 USD 在3天之内
5.0 (5条评论)
1.4
1.4
用户头像
See private message.
$14.45 USD 在3天之内
3.2 (2条评论)
0.1
0.1
用户头像
See private message.
$8.50 USD 在3天之内
5.0 (2条评论)
0.0
0.0
用户头像
See private message.
$12.75 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
See private message.
$17 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

NETHERLANDS的国旗
Netherlands
4.9
13
付款方式已验证
会员自10月 31, 2007起

客户认证

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