AnsweredAssumed Answered

Help required ASAP to design a new layout within my database

Question asked by danielle-gwa on Oct 11, 2013
Latest reply on Oct 11, 2013 by TimDietrich

Hi everyone,

 

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.

 

e.g.

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!

 

thanks

 

Danielle-gwa

Outcomes