freight charges

I am just beginning my dealings with access.  We ship our product to different destinations and apply different freight for each piece for each destination instead of a total freight for the destination.  The unit cost of each piece is the same, but the freight for each piece for each destination is different.  What do I need to do to set this factor up?

Also, could you recommend a course, video, book, online tutorial or anything to help get me started.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

For reference on Access programming, it's Access Developer's Handbook, published by Sybex, written by Getz, Gilbert, and Litwin.

For your specific question, I'm guessing that there isn't a simple formula you could use, i.e., 10 percent of unit cost, to calculate freight. If that's true, then here's what I'd recommend:

1. Create a table of freight charges. This table would include the product name or ID, the destination, and the charge per unit.

2. On your form for data entry, you can get the freight charges in one of two ways; the method you choose would depend on whether you need to *store* the freight charges or just have them for display, printing, etc. (If you don't store them, you could get them any time through a query using a link to the table created in Step 1.)

simple way (no storage): put a text box on the form for freight. Set its ControlSource to
   =[Quantity] * DLookup("PricePerUnit", "FreightChargesTable", "ProductID" = '" & ProductID & "'")

This multiplies a quantity entered in a text box on the form by the associated PricePerUnit in the table we created in Step 1.

For storage, I would do the same kind of idea. Set the ControlSource to the name of your FreightCharges field, and then on the AfterUpdate event of the quantity text box (and/or product) put this code:
   FreightCharges = me.Quantity * DLookup("PricePerUnit", "FreightChargesTable", "ProductID" = '" & ProductID & "'")

Let me know if you have any questions on how to work either of these out.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cdevaroAuthor Commented:
Thanks.  I'll give this a try.
cdevaroAuthor Commented:
I appreciate the help.  I'll give it a try.  
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Like I said, if you have any questions, let me know. Generally on EE, the questioner will try the suggestions first and then, if they work, will award the points. Otherwise, some experts might take your points and run away. I won't, but it can happen. In the future, hold off until you are sure that the proposed comment or answer works for you. Thanks, cdevaro, and welcome to EE!
Hi Cdevaro,

Any update on this question?

in an effort to clean up old open questions

your options are:

1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you, but may help others. You must tell the
participants why you wish to do this, and allow for Expert response.  This choice will include a refund
to you, and will move this question to our PAQ (Previously Asked Question) database.  If you found information
outside this question thread, please add it.
3. Ask Community Support to help split points between participating experts, or just comment here with
details and we'll respond with the process.
4. Delete the question (if it has no potential value for others).
 --> Post comments for expert of your intention to delete and why
 --> You cannot delete a question with comments, special handling by a Moderator is required.

For special handling needs, please post a zero point question in the link below, include the question


Please click this Help Desk link for Member Guidelines, Member Agreement and the Question/Answer process:
Click you Member Profile to view your question history and keep them all current with updates as the
collaboration effort continues.

------------>  EXPERTS:    Please leave any comments regarding this question here on closing recommendations
if this item remains inactive another seven (7) days.

Per recommendation, force-accepted by
CS Moderator
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.