I need some help asap:-
The main table in my database contains 4000 parts (PART table)
I have other linked tables- for example a table that show usage of parts at different sites on specified dates- which links back to the PART table via part number
I need to create a report that shows me which of the 4000 parts are used on 3 of the sites within a certain 2 year time period chosen individually for each site.
Part number 12345 is used 3 times on SITE A within the date period specified 01/01/2010 to 01/01/2012
Part number 12345 is used 2 times on SITE B within the date period specified 01/01/2006 to 01/01/2008
Part number 12345 is used 5 times on SITE C within the date period specified 01/03/2010 to 01/03/2012
Can anyone help me design a layout within my system to allow me to do this??
Help asap would be very very appreciated!