Sorry, looks like I did not give enough info.
I have two tables, one with all the sales information including the date the sale was made. The other table contains the part revision information. This table lists the part number which was revised and the date of the revision. Each part can be revised any number of times during its life cycle. I need to produce a report of all the sales for each part that has been revised for periods starting...
jdc73
Last Activity: Feb 10 '12, 07:56 PM
Joined: Feb 9 '12
Location:
-
Complicated date selection
I have a table that has part numbers with affectivity dates like so
Part 1 01/01/2003
Part 2 07/15/2004
Part 1 09/30/2005
Part 2 11/26/2006
Part 1 12/15/2007
I need to find all the Parts sales for each part between the first effectively date and the next effectively date and then the sales between the second...
No activity results to display
Leave a comment: