query to make a list of products based on delivery history

[tsison7]

I have a table which lists all deliveries made of our product. From this
table, I'd like to make a list of all products. My problem is the products
will have many duplicates as they can be ordered multiple times and I just
want a list showing all the individual products that we offer.

 

[Duane Hookom]

Try something like:

SELECT DISTINCT [our product]
FROM [which list all deliveries made];

If you can't figure this out, come back with table and field names.

 

[tsison7]

Duane,

I tried that but that only generates a single column list showing the one
field. How can I add additional fields for each of the unique records....for
instance (product description, price)
--
TIA

Try something like:

SELECT DISTINCT [our product]
FROM [which list all deliveries made];

If you can't figure this out, come back with table and field names.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

I have a table which lists all deliveries made of our product. From this
table, I'd like to make a list of all products. My problem is the products
will have many duplicates as they can be ordered multiple times and I just
want a list showing all the individual products that we offer.

 

[tsison7]

Duane,

Nevermind, I used the following to solve my problem:

SELECT [our product], last(description), last(customer)
FROM [which list all deliveries made]
GROUP BY [our product]

--
TIA

Duane,

I tried that but that only generates a single column list showing the one
field. How can I add additional fields for each of the unique records....for
instance (product description, price)
--
TIA

Try something like:

SELECT DISTINCT [our product]
FROM [which list all deliveries made];

If you can't figure this out, come back with table and field names.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

I have a table which lists all deliveries made of our product. From this
table, I'd like to make a list of all products. My problem is the products
will have many duplicates as they can be ordered multiple times and I just
want a list showing all the individual products that we offer.