Find Jobs
Hire Freelancers

Access report

$30-5000 USD

Cancelled
Posted about 16 years ago

$30-5000 USD

Paid on delivery
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
Project ID: 3738148

About the project

3 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $54 USD for this job
User Avatar
See private message.
$85 USD in 1 day
4.9 (409 reviews)
7.1
7.1
User Avatar
See private message.
$34 USD in 1 day
4.6 (9 reviews)
2.7
2.7
User Avatar
See private message.
$42.50 USD in 1 day
0.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
United States
4.8
50
Member since Oct 1, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.