Append filter data from multiple tables to one table
Posted on 2012-08-17
Ok I have 3 tables that I need to pull data from and put the results into 1 table. The part I am stuck on is the filtering part. In the query, Where should be the current month from tblworkform date field. Any help would be greatly appreciated! This question is kinda tough to word so if more information is needed, please let me know. Thanks in advance!
INSERT INTO tblmonthlyreport ( wkdate, wkname, wktotalhrs, wkstorenumber, opdatepurchased, opname, opstorenumber, ptneeded, ptdateordered, ptstorenumber )
SELECT tblworkform.Date, tblworkform.Name, tblworkform.[Total Hrs], tblworkform.[Store Number], tblops.[Date Purchased], tblops.[Op Name], tblops.[store number], tblepartsform.[Parts Needed], tblepartsform.[Date Ordered], tblepartsform.[store number]
FROM tblworkform, tblops, tblepartsform