Using Calculated Fields in Queries

[MikeKohler]

I have a field which calculates the cost of parts, the price field * quantity field. I have this set up in a form and the data is stored in its table with no problem. However, when I run a query using this table, none of the numbers for the cost field show up, and when I go to the corresponding data, all the data for the cost field has been deleted. Does anybody know what is going on?
-Michael K.

 

[THoey]

Please go to the SQL view of the query and post the code here. It is difficult to *guess* what might have happened... Terry M. Hoey

Please read the following FAQ to learn how to help me help you...

faq183-874

 

[MikeKohler]

Here is the SQL Code:
SELECT Parts.PartID AS Parts_PartID, Parts.PartName, Parts.PartDescription, Parts.NameId, Parts.Cost, partsub.ID, partsub.Quantity, partsub.TotalCost
FROM Parts INNER JOIN partsub ON Parts.PartID = partsub.PartID;
Thanks for looking at my problem,
Michael K.