|
 |
access thread: Storing Calculated Fields
Message #1 by "Pritesh_b" <pritesh_b@t...> on Fri, 30 Nov 2001 14:06:07 -0000
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_007E_01C179A8.27E0B8F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a table which stores Net Amount, VAT Amount, Total Amount ..
VAT and Total Amounts are calculated, which is the best way to store
these to access?
Please advise
Message #2 by Walt Morgan <wmorgan@s...> on Fri, 30 Nov 2001 08:22:02 -0600
|
|
Pritesh_b,
Generally it is not considered efficient to store any value that can be
created from existing fields. However, I have found that when it comes to
reporting, having to deal with only one table has the advantage of
simplicity. It does violate the normalization rules of data storage. An
additional consideration, though admittedly a diminishing one is the cost of
storing the superfluous data.
In the end I would say it is up to you.
Regards,
Walt
Message #3 by "Clive Astley" <clive.astley@p...> on Fri, 30 Nov 2001 16:17:08
|
|
I have authored a program that handles thousands of VAT calculations in
many different ways. It does not store any of the calculated fields but
generates them afresh on the fly when needed. Hope this helps.
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I have a table which stores Net Amount, VAT Amount, Total Amount ..
>
> VAT and Total Amounts are calculated, which is the best way to store
> these to access?
>
> Please advise
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html;
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>I have a table which stores Net Amount,
> VAT Amount,
> Total Amount .. </FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>VAT and Total Amounts are calculated,
> which is the
> best way to store these to access?</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Please
> advise</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0--
>
Message #4 by "Clive Astley" <clive.astley@p...> on Fri, 30 Nov 2001 18:19:54
|
|
Further to my earlier post. I hope this is not teaching grannies to such
eggs - if so I apologise. It's just that I've seen "professional" programs
make the following mistake which causes embarrassment at the VAT100 stage.
Don't forget that many VAT transactions are not exactly 17.5%. They are
17.5% rounded up to the next penny for input tax and 17.5% rounded down to
the next penny for output tax. Of course, substitute 17.5% with 8.25%, 8%,
5% or 4% if you are using one of those other rates (8% is now obsolete but
as some fuel suppliers still use it it makes sense to include it in a VAT
program).
Hope all this helps. Best wishes.
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I have a table which stores Net Amount, VAT Amount, Total Amount ..
>
> VAT and Total Amounts are calculated, which is the best way to store
> these to access?
>
> Please advise
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html;
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>I have a table which stores Net Amount,
> VAT Amount,
> Total Amount .. </FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>VAT and Total Amounts are calculated,
> which is the
> best way to store these to access?</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Please
> advise</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0--
>
Message #5 by "Ian Ashton" <ian@c...> on Fri, 30 Nov 2001 19:15:25 -0000
|
|
Just a thought:
What will happen when the VAT Rate changes and you wish to view the
historical data of what the VAT amount actually WAS at the time the record
was created?
Ian Ashton
-----Original Message-----
From: Clive Astley [mailto:clive.astley@p...]
Sent: Friday, November 30, 2001 4:17 PM
To: Access
Subject: [access] Re: Storing Calculated Fields
I have authored a program that handles thousands of VAT calculations in
many different ways. It does not store any of the calculated fields but
generates them afresh on the fly when needed. Hope this helps.
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I have a table which stores Net Amount, VAT Amount, Total Amount ..
>
> VAT and Total Amounts are calculated, which is the best way to store
> these to access?
>
> Please advise
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html;
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>I have a table which stores Net Amount,
> VAT Amount,
> Total Amount .. </FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>VAT and Total Amounts are calculated,
> which is the
> best way to store these to access?</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Please
> advise</FONT></DIV>
---<BR>
You are currently subscribed to access as: ian@c...<BR>
To unsubscribe send a blank email to $subst('Email.Unsub')<BR>
Read the future with ebooks at B&N<BR>
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&ca
tegoryid=rn_ebooks
</BODY></HTML>
>
> ------=_NextPart_000_007E_01C179A8.27E0B8F0--
>
|
|
|
View Cart
