How can I store Sales Tax rate in detail records

[ovonel777]

Hi

I have a form/subform for invoices. I need to be able to store the
sales tax rate for each record
in the invoice details subform. If the tax changes, I will have the
tax rate that was in effect at the time the invoice was generated.

I have the tax rate stored in a table called "Company". I would like
to get the tax rate from this table if possible. If I have to "hard
code" the tax rate that is ok too.

Please let me know how to get the tax rate into the detail records.

Thanks
Mark

 

[ruralguy via AccessMonster.com]

Hi Mark,
Your request is common for invoicing systems. Do you have a field in the
SubForm's RecordSource in which to put the tax rate? How are you retrieving
the rate currently?

 

[ovonel777]

Hi Mark,
Your request is common for invoicing systems. Do you have a field in the
SubForm's RecordSource in which to put the tax rate? How are you retrieving
the rate currently?









--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

Thanks for your reply

I have a field called tax rate in invoice detail table. I am not
currently retrieving the tax rate. I hard coded the tax rate in a
query.

Mark

 

[ovonel777]

Hi Mark,
Your request is common for invoicing systems. Do you have a field in the
SubForm's RecordSource in which to put the tax rate? How are you retrieving
the rate currently?









--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

Thanks

I thought I replied but I didn't see my post.

I have a field in the invoice detail table called "tax rate". I am
not currently retrieving the tax rate. I am in the design phase.

Mark

 

[ruralguy via AccessMonster.com]

Can you join your tax table in the query? If not then maybe a DLookup() will
work for you.

Hi Mark,
Your request is common for invoicing systems. Do you have a field in the

[quoted text clipped - 23 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

Thanks for your reply

I have a field called tax rate in invoice detail table. I am not
currently retrieving the tax rate. I hard coded the tax rate in a
query.

Mark

 

[ovonel777]

Can you join your tax table in the query? If not then maybe a DLookup() will
work for you.

Hi Mark,
Your request is common for invoicing systems. Do you have a field in the

[quoted text clipped - 23 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

Thanks for your reply

I have a field called tax rate in invoice detail table. I am not
currently retrieving the tax rate. I hard coded the tax rate in a
query.

Mark

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

I can join the tax rate in the query, but I need to know how to
actually store the tax rate in the invoice detail table.

Mark

 

[ruralguy via AccessMonster.com]

There are several ways Mark. It depends on how you have things set up. You
could use the AfterUpdate event of maybe the quantity control to copy the tax
rate to your field if your field is currently empty.

Can you join your tax table in the query? If not then maybe a DLookup() will
work for you.

[quoted text clipped - 21 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

I can join the tax rate in the query, but I need to know how to
actually store the tax rate in the invoice detail table.

Mark

 

[Rockn]

How are the tax rates determined, by customer, by state? I do something
similar in an order database I have created where each builder has a
different percentage they charge over a standard cost. If the job is based
on a given builder the percentage is brought into the job table at the time
the job is created and all calculations on invoces are based on the job and
this percentage.