MS Access Table Set Up - Make(merge) Table Query??

[Randy11]

Have created a query that Makes a table from 2 others. Problem I have is that the Record ID number starts where ever it last left off in the new table & The new data does not write over top of what is in this table. Want it set up so that each time Data is dumped in the table it starts at record number 1 & writes over all data in the file.

SELECT [qryRB Userruns Merge].FullName, [qryRB Userruns Merge].City, [qryRB Userruns Merge].SumOfPRNTnet_time, [qryRB Userdown Merge].SumOfNPnet_time, qryTimeDifferenceFullSum.[Sum Of IdleTimeHrs]
FROM ([qryRB Userruns Merge] LEFT JOIN [qryRB Userdown Merge] ON [qryRB Userruns Merge].FullName = [qryRB Userdown Merge].FullName) LEFT JOIN qryTimeDifferenceFullSum ON [qryRB Userruns Merge].FullName = qryTimeDifferenceFullSum.FullName
ORDER BY [qryRB Userruns Merge].FullName;

 

[vbkris]

try using views?

Known is handfull, Unknown is worldfull