View Single Post
  #2 (permalink)  
Old August 30th, 2004, 07:31 AM
jemacc jemacc is offline
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Suggestion:

Avoid storing calculated fields. Create a table that stores this information and create a query and do your calculation there.

Take a look at the northwind access database that comes with MS Access

[u]Tables</u>
Order
Order Details

This will give you and idea on how to best approach your situation.


Reply With Quote