Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inventory BD (Access 2000)

    I Have a DB that list my inventory. I need to make a query to list the products that i receive each day. I have a query that makes a table with the description already. My problem is that it only list it one time. I need it to list it a different number of times each day. How can i get the make table query ask me have many. EXAMPLE ( if a have 30 Widgets today. I would run the query. If I enter wedgets and then enter 30. My end result would be a table with 30 rows of the description widgets) .

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Inventory BD (Access 2000)

    Do you really want 30 identical records with the description Widget? Wouldn't it be better to have one record with description = Widget and number = 30?

    It is possible to add identical records using a query (I would guess that you need an append query for this rather than a make table query), but the only way I can think of now is a clumsy kludge. Another way is to use code; I don't know if and how familiar you are with programming in Access.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Inventory BD (Access 2000)

    If you want to return all those rows, you need to use the DistinctRow keyword. In your SQL statement, use "Select DistinctRow .....", or with the QBE grid displayed, select the query properties and set the "Unique Records" property = Yes.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •