Help - Advice Needed

[ninja_imp]

Hi

Im currently building a database which holds customer delivery options, quantities, unit and delivery price and so on.

It has all been going fine until now...!

I am trying to setup the billing aspect. My main headache is that each customer could have a delivery every day, of different quantities. Now there will be times when this customer goes on holiday and of course doesnt need to have anything delivered - my only problem is getting the billing to adjust accordingly.

I have my SubForm which contains:

UnitName
UnitPrice
Mon
Tues
Wed
Thursday
Fri
Sat
Sun
DeliveryCost
TotalCost


at the moment in the main form the holiday period is put in and i convert this then into a number of days value - this is then subtracted from the total of units (count of Mon to Sun) x UnitPrice + Delivery.

My problem is that if a customer has 2 days off which are Mon and Tues, how do i get it to only remove the mon and tues values from the unit amount - instead of just removing a figure assuming that they have only 1 per day - wihch in most cases they don't.

Can i somehow assign the day values to each day field in the subform and get the correct days from the holiday or something!

i dont know its just breaking me down!!!

Any help greatly appreciated

 

[supercharge]

Looks like a lot for info needed to understand your situation. How is data-entry done? How does your billing work......?

 

[ninja_imp]

Hope this explains

hi

I have attached a screenshot of the main customer screen. You will see 2 sub forms. 1 shows each publication for that customer - which day they want delivery and how many and the other shows if they have a holiday and where the date is inputted.

Now if only a single value is put in in each day i can get it to work out fine - but if they only choose to have a delivery on a monday and tuesday - and they have 3 of a particular item on a tuesday - how do i get it to remove that figure.

What i need it to do is see each field in my table as its day - So the 'Mon' Field needs to be seen as the day of monday - i was figurng this could be done with the VbMonday somehow but not sure how to implement it. Then get it to understand the holiday days and tell which holiday day is which day of the week and then if the holiday day equals any of the delivery days dont include that amount in the calculation.

It all seems very confusing and im probably not explaining it all that well but i hope someone out there has something to offer in the way of enlightenment!

Cheers

 

[supercharge]

Still don't get it!!!!!

...
Now if only a single value is put in in each day i can get it to work out fine - but if they only choose to have a delivery on a monday and tuesday - and they have 3 of a particular item on a tuesday - how do i get it to remove that figure.
So these values are manually entered? The values can be more than 1? How are your totals calculated? So what you're saying is that if the values are all 1's then you can get it to work out and not otherwise?

What i need it to do is see each field in my table as its day - So the 'Mon' Field needs to be seen as the day of monday - i was figurng this could be done with the VbMonday somehow but not sure how to implement it. Then get it to understand the holiday days and tell which holiday day is which day of the week and then if the holiday day equals any of the delivery days dont include that amount in the calculation.

I'm afraid that eventually you may have to submit a sample of your program for us to understand clearly of what you're trying to accomplish! Sorry. I don't think it will be a difficult problem, I'm just not clear.