Thread: Counting from two tables.

Do the tables include an identifier by which you can ascertain which product was sold and when that specific product broke? (something like a transaction number, or in the case of multiple line transactions, a transaction number plus item ID?) You need some way of identifying which breakage event corresponds with the item from which purchase event.

I do have some other fields such as a Serial Number and a ID Number. What would I do with that?

You'll need to join the two tables (in your query) by something common such as serial number - then you can calculate the difference between the bought date in one table and the broken date in the other, for corresponding pairs of records.

The thing is I need to count the date of the products bought because they could be the same date. ex: Broke 1/1/01 1/3/01 Bought 1/2/01 1/2/01 1/2/01 1/2/05 so the output table will look like Date 1/1/01 - 1/2/01 3 1/3/01 - Present 1