Re: Form with multiple variables

Tech-Archive recommends: Speed Up your PC by fixing your registry

RiRi,
Given the data you presented...
You wrote...
Therefore a specific rate is based on the combination of the
above variables.

What combination? You haven't indicated how you caclulate
your 5 pricing schemes.
How do you calculate Rate4... as opposed to RateJ... etc...
from the field values you showed for Cycle, Client, and ShipCode?
Those "text" values may influence the pricing, but without a pricing
formula for 5,8 7, T, and J rates... I have no idea.

You wrote...
Density is done by Net weight of the shipment divided by Cubic footage.

Now this is a "formula" I can understand.
But, where are those values in your Invioce?
It would seem to me that you should have values indicated in your Invoice
for NetWeight, Length, Width, and Height values. Then the calculation would
be...
Density = NetWeight / (Length * Width * Height)

If you're asking for help in calculating different pricing structures, we
need to know the formulas for each, and sample values involved.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


"RiRi" <me@xxxxxxxx> wrote in message
news:5eQMj.120328$yE1.26752@xxxxxxxxxxxx
Thank you Al, I will try to explain.
The purpose of the database is invoicing shipments to our clients
(possibly in future keeping record of what we were invoiced by suppliers).
The Rate of invoicing depends on 5 variables:
1 - Cycle (we have 2 cycles per year: summer and winter and they are
identified like this: "IS08" is summer 2008, "IW08" is winter 2008,
"IS09" is summer 2009, "IW09" is winter 2009 and so on.)
2 - Client (every client has different rate we invoice)
3 - Code of shipment ( we have 5 types of shipments i.e. baggages, freight
in containers etc. and everyone has different rate)
4 - In or Out (if the shipment is delivered or picked up)
5 - Some types of shipments have a specific rate based on Density of the
shipment itself
Therefore a specifi rate is based on the combination of the above
variables.
So I have a table with the shipment information (name, customer, weight,
type of shipment etc)
I created a form that displays the table info.
From the info we input on this form were I indicate all the variables
indicated above, I would like to have the specific rate on the form for
the final invoicing.
I have codes for clients:
AAAA
AAAB
AAAC
etc
I have codes for the shipments; 5,8 7, T, J
I have codes for the cycles: IS08 (current)
I have codes for "Inbound" or "Outbound" Shipment in or out.
Density is done by Net weight of the shipment divided by Cubic footage.

I have a table were I indicate the rates as following:
Cycle Client Type of shipment Rate 4
Rate J Rate 7 Rate 8 Rate T
IS08 AAAA Inbound 0.00
0.00 0.00 0.00 0.00
IS08 AAAA Outbound 0.00 0.00
0.00 0.00 0.00

And so on.
I still have not figured out the density variable thoug...


Sorry for the long post

R




"Al Campagna" <newsgroups@xxxxxxxxxxx> wrote in message
news:OXpjIldnIHA.2268@xxxxxxxxxxxxxxxxxxxxxxx
RiRi,
I'm not sure that you're dealing with variables. It sounds like you
have 3 individual field values in a table that you need to "join"
together to form some sort of an InvoiceNo?
Please provide some example values of your field values, and show us
what you want to do with those values.
"This is what I have... and this is what I'd like to see."
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

"RiRi" <me@xxxxxxxx> wrote in message
news:AbyMj.119098$yE1.24143@xxxxxxxxxxxx
HI,
I am stuck.
I have a form in which there are 3 variables (inbound/outbound shipment,
code of service of the shipment, Client)
The combinations of these 3 variables should show me only the correct
rate on the form, from which I can go on and invoice...
So the rate is a combination of the above variables.
The variables are part of 3 tables....
How do I do that?


R








.

Relevant Pages

  • Re: Form with multiple variables
    ... Shipment main table for calculations) ... from the field values you showed for Cycle, Client, and ShipCode? ... Those "text" values may influence the pricing, ... The purpose of the database is invoicing shipments to our clients ...
    (microsoft.public.access.formscoding)
  • Re: Form with multiple variables
    ... The purpose of the database is invoicing shipments to our clients ... - Client ... - In or Out (if the shipment is delivered or picked up) ... I have codes for the shipments; ...
    (microsoft.public.access.formscoding)
  • Re: Form with multiple variables
    ... The purpose of the database is invoicing shipments to our clients (possibly ... - Client ... - In or Out (if the shipment is delivered or picked up) ... I have codes for the shipments; ...
    (microsoft.public.access.formscoding)
  • Re: Its summer, you need t-shirts
    ... before where to get MAME related t-shirts. ... if the pricing is okay, ... "Shipment outside the United States is not currently available." ...
    (alt.games.mame)