add colomn,show duplicate record w/each month?

[mrenshaw]

I have a table of parts numbers. I have a table with 12 dates. I need to combine the dates and part #'s table and for each part number, list the 12 dates. For example,
Part # Date
001 010203
001 020303
001 030303
001 040103
001 050103
001 070103
etc. etc.
I could have someone key the dates in but this would take forever. Basically I have one part number and would like to run a query showing the part number 12 times with the 12 dates. The dates are the first working day of the month. Any help would be greatly appreciated.

Thanks,

Michael

 

[mrenshaw]

Figured it out, thanks anyway.