Mixaalser684 Posted April 19, 2008 Share Posted April 19, 2008 Look at this page Example.Now look at the part: Card instances 1 to 10 of 1853 (total quantity not included) You see the number 1853? That is not the total amount of cards I have in database. The total amout is around 3000. Now the database counts only how many times some card with the specific name appears in database but it doesn't count how much in quantity I have of each card that appears. The quantity number is represented with the "#" symbol. Now do I add the quantity for each specific card? Link to comment Share on other sites More sharing options...
justsomeguy Posted April 21, 2008 Share Posted April 21, 2008 What does the database structure look like where you store the cards? Link to comment Share on other sites More sharing options...
Mixaalser684 Posted April 21, 2008 Author Share Posted April 21, 2008 What does the database structure look like where you store the cards?I'm not quite sure I understood the question. Link to comment Share on other sites More sharing options...
justsomeguy Posted April 21, 2008 Share Posted April 21, 2008 What is the structure of the table that holds the cards? By structure I mean the names and data types of all of the fields in the table. Link to comment Share on other sites More sharing options...
Mixaalser684 Posted April 21, 2008 Author Share Posted April 21, 2008 What is the structure of the table that holds the cards? By structure I mean the names and data types of all of the fields in the table. tblCardsintCardID (P.K. - Long Integer - Autonumber) txtCardName (Text 255)intQuantity (Long Integer)bitFoil (Yes/No)dblPrice (Double)memComment (Memo)intEditionID (Long Integer - Duplicates OK)intColorID (Long Integer - Duplicates OK)intConditionID (Long Integer - Duplicates OK) Link to comment Share on other sites More sharing options...
justsomeguy Posted April 21, 2008 Share Posted April 21, 2008 If you sum the intQuantity field it should tell you how many cards there are total.SELECT SUM(intQuantity) AS num FROM tblCards Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.