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


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

Order Details

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

Reply With Quote