Inventory BD (Access 2000)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote