Find Jobs
Hire Freelancers

Access report

$30-5000 USD

已取消
已发布大约 16 年前

$30-5000 USD

货到付款
Attached is a database. I need a report like 'Report - Shipping by week (detail by freight)' this report is basedd on the "Query: Orders to ship" but instead of printing all orders at once like in the aforementioned report, I need the following. 1. I'd like the database to prompt me for the Cust_PO that I'd like to print. 2. When I enter the PO, I'd like the database to print a report, in a 4x6 sheet, and the report will include the following fields PO: "Cust_PO" Shipping Date: "Shipping_Date" Ship via: "Ship_Via_Company" Customer: "Cust_Name" "Ship City", "Ship_State" Then, I need the report to list the items ordered on the particular PO Quantity - Item - Box Subform_qty - Item_ID - Box_type But the list only can have the maximum number of trays that a particular box_type can hold. So first the items for a the entered Cust_PO needs to be grouped in Box_type. So all the items with a box_type of Box23, they need to be group in one page. If that page does not exceed the Trays_per_box then, it can print all the items in that page, if not, it needs to print the remaining items in another page, until it prints them all. The number of trays is already calculated in the "Query: Orders to ship", the calculation is Trays: [Subform_qty]/[Tray] Once it has listed all the items for all box types, then it's done. A label can only be for one box type. Does this make sense? I need this to be done asap. Thanks! daniel
项目 ID: 3738148

关于此项目

3提案
远程项目
活跃16 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
3威客以平均价$54 USD来参与此工作竞价
用户头像
See private message.
$85 USD 在1天之内
4.9 (409条评论)
7.1
7.1
用户头像
See private message.
$34 USD 在1天之内
4.6 (9条评论)
2.7
2.7
用户头像
See private message.
$42.50 USD 在1天之内
0.0 (1条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
4.8
50
会员自10月 1, 2003起

客户认证

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