Here's my Query:
SELECT TOP 2 [Companies].PRODUCT, [Companies].CUSTOMER,
[Companies].DATE,[Companies].[ID Number]
FROM [Companies]
WHERE ((([Companies].PRODUCT)="A") AND
(([Companies].CUSTOMER)="Company N.B."))
ORDER BY [Companies].DATE DESC
QUESTION:
How do I create one query that gets the last 2 Order dates
for each separate company and product that the particular
company orders??
Example of Part of Table:
Companies Product Order Date
Company NB A April 1, 2003
Company J A April 15, 2003
Company NB A May 20, 2003
Company NB B May 21, 2003
Company J A May 13, 2003
Company J C June 3, 2003
Company J A June 9, 2003
Company NB A June 9, 2003
Example: I would like the query to give me the following
Data:
Companies Product Order Date
Company NB A June 9, 2003
Company NB A May 20, 2003
Company NB B May 21, 2003
Company J A June 9, 2003
Company J A May 13, 2003
Company J C June 3, 2003