RichJr Posted August 3, 2000 Share Posted August 3, 2000 I have set up a relational database, one a product database that stores the SKU; description; price. Another database with order info such as name; address; etc, and the three previous fields related from the products database. And a calculation field names total which calculates price*qty. The field all work fine except for this one which turns up 0. Does anyone know why this is happening? if this is not enough information please email me. [email protected] ------------------ Rich Link to comment Share on other sites More sharing options...
ryan93 Posted August 7, 2000 Share Posted August 7, 2000 How do you get the price from the original file to the file with name, address, etc? Is it a lookup? Calculation? If calculation do you have the result set to number? If it's text it won't work. Is your price field set up as a number field and not a text field? There are many things to consider with this problem. Yes we'll need more info. But first remember this, anytime you do calculations you need a field that is set as a number. Check the fields associated with this calculation and make sure they are number fields or pre-existing calculations. Ryan [email protected] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8671 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now