Calculation Help!!! (1 Viewer)

[lfoulsha]

Is this possible?
In my invoice form I have 3 different tax rates. I have put a calculation in each of the Control Sources to calculate the invoice sub total:​

=[Invoice Sub Total]*0.13​

=[Invoice Sub Total]*0.05​

=[Invoice Sub Total]*0.09975​

I don’t always use all the tax rates. I would like to be able to go back into a tax rate field I don't need and delete it.​

 

[plog]

I don’t always use all the tax rates. I would like to be able to go back into a tax rate field I don't need and delete it.

The terms you are using don't make sense. 'Field' is a column in a table, 'Control' is a part of a form that can display data from a field. So when you are talking about forms and wanting to delete data from fields, it doesn't make sense.

It especially doesn't make sense when you say 3 of your controls are calculations. Calculations are not stored in fields, so deleting them doesn't make sense. You can hide controls on a form. Is that what you want? If not, can you better describe what you want to occur?

 

[lfoulsha]

I am new to Microsoft Access and really struggling! Here we go again...
As I said I am in my Form (Design View) and have opened the Property Sheet. I click on the box (Text Box) where I have the tax calculation which I entered next to the Control Source: =[Invoice Sub Total]*0.05 - does this make more sense - I don't know how else to describe it. As I said before, since this is an automatic calculation, I would like to be able to delete it if I don't need this particular rate. Is it possible to add some kind of function to =[Invoice Sub Total]*0.05 so that I can do this?

 

[plog]

You can hide it using VBA. You could put a check box beside it to toggle it on and off. If that box is checked it displays the cacluation, if not it doesn't.

For that you would put the check box control on the form, add an OnClick event to it and then set the value of the corresponding calculation to be show/not show when the checkbox is clicked/not clicked.

 

[Simon_MT]

It would be tempting to consolidate the tax rates combinations and then have a separate table with the components. The only problem is when these rates change.

Simon

 

[lfoulsha]

Hi Simon:
It seems we are not speaking the same language at all. My question is basically very simply. When I am in my invoice form and I enter the invoice sub total, the calculation in each of the tax rates is done automatically. Unfortunately, here in Canada, we have different tax rates for each province so that when I prepare an invoice, for let's say, Quebec, I have to charge GST 5% and QST 9.975%, but when I prepare an invoice for Ontario I only charge the HST 13%. What I would like is to be able to go into the tax rate I don't need and delete it. Is this possible?

 

[Simon_MT]

I'm aware of differing GST and State or Provincial Taxes in fact Florida has scalular (bands) taxes. I understand the difference between Federal and local sales taxes. Even more difficult is Margin Sales on the profit of individual sales and then again Europe has specific Art taxes just to be different.

So I would still be inclined to have one province Tax and a separate table with each province taxes store the component sales tax.

If you have a field for the different types of taxes you could there forever modifying each and every sales tax permutation.

Simon

Simon

 

[lfoulsha]

Hi Simon:

I give up!! :banghead:
I am brand new to Access, and I have no idea how this is supposed to work. If I set up the table, how is it connected to my form, etc., etc. Also, what happens when I have two taxes or I could even have the three on the same invoice. It would not be a big problem when I enter an invoice to go into each tax rate I don't need and delete it. There must be a simpler way.

Lise

 

[Simon_MT]

You need a Sales Tax table and this is where you made accomodate the variety of sales tax. then underneath that the components so that the bean counters know is how much tax to pay for type of sales tax.

It is actually comparatively simple just another dimension within sales tax data structure.

Simon

 

[lfoulsha]

As I have said from the beginning, I am brand new to Microsoft Access, I don't speak the language.

You are presuming I know how to set this up.....I can set up a table with my 3 sales taxes and then, how does it connect to my form? How do I pick the sales tax(es) I need in my form....I have no idea!

Lise

 

[Simon_MT]

You then have a Sales Tax Field and Value Field with a dropdown list and you pick the applicable Sales Tax.

AfterUpdate you set the Sales Value to relevant sales tax rate either by setting if to the column in the sales tax combi-box or via a query that links the Sales Tax Table with the Invoice Table.

Simon

 

[lfoulsha]

Hi Simon:

Thanks for trying to help....I still have no clue....so I truly, truly, give up. The solution is that I will enter each tax manually...end of story.

Lise

 

[williamMorin]

Hi Simon:
It seems we are not speaking the same language at all. My question is basically very simply. When I am in my invoice form and I enter the invoice sub total, the calculation in each of the tax rates is done automatically. Unfortunately, here in Canada, we have different tax rates for each province so that when I prepare an invoice, for let's say, Quebec, I have to charge GST 5% and QST 9.975%, but when I prepare an invoice for Ontario I only charge the HST 13%. What I would like is to be able to go into the tax rate I don't need and delete it. Is this possible?

hi..
Sadly, most invoice tools don't let you delete tax lines directly for each invoice. But you can usually set tax rules by province, so only the correct rate (like HST or GST/QST) applies based on the customer's location. Check if your system supports region-based tax settings.
thank you

 

[Gasman]

hi..
Sadly, most invoice tools don't let you delete tax lines directly for each invoice. But you can usually set tax rules by province, so only the correct rate (like HST or GST/QST) applies based on the customer's location. Check if your system supports region-based tax settings.
thank you

11 year old thread?

 

[Mark_]

11 year old thread?

I've noticed a lot of thread necromancy lately. I wouldn't expect this much until October!