Jump to content

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?

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)
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.

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.

  • Create New...