Jump to content
Sign in to follow this  
Mixaalser684

Counting All Record Instances * quantity

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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)

Share this post


Link to post
Share on other sites

If you sum the intQuantity field it should tell you how many cards there are total.SELECT SUM(intQuantity) AS num FROM tblCards

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...