need some help with an update query.

[Jon123]

I have a problem I dont know how to resolve. I have users that work a 24 / 7
contract. Our big issue is users do not have any type of internet access what so ever at customers sites. This make it very hard to do any type of databases. However, we tried setting one up that would work offline. So the way this database works is someone creates a new job. At the end of their shift they have an export button that exports their job and removes its self from there database competely. (it goes to a mem stick) The user coming in
to take over then get the mem stick and they have an Import button that moves the file from the stick into their dbase and they continue working on that job. At the end of the job they need to email the completed job to an admin to upload it the the master dbase that keeps records of all of the completed jobs. Now this is where my problem comes in. I have a field primary key auto number called WCID and this number gets started by any ones program so the possible is there where the admin would be uploading a record that already has that ID used so it wont upload. Is there a way in the update query where I could have the WCID update the the last record entered plus 1?

Jon

 

[dcb]

I have a field primary key auto number called WCID and this number gets started by any ones program so the possible is there where the admin would be uploading a record that already has that ID used so it wont upload. Is there a way in the update query where I could have the WCID update the the last record entered plus 1?

Jon

If its a autonumber it will be automatically assigned if you dont specify it
If not then some simple code with a query should work:
select TOP 1 WCID from wcidTable order by WCID desc
get the resut and add one

remember that you need to carry this over into any linked tables (assume you have that covered)

 

[Jon123]

Sorry I'm not following

On the main table that stores all of the complete jobs I would change the WCID from an auto number and have code in the qry grid for the append query for the field WCID.

???

Jon

 

[dcb]

Sorry I'm not following

On the main table that stores all of the complete jobs I would change the WCID from an auto number and have code in the qry grid for the append query for the field WCID.

???

Jon

On your main database do you have one table that stores the completed info?
Is WCID a autonumber field?
Could you paste your current update query?

 

[Jon123]

Here is the qry it uses [wet clean ID] as the autonumber

INSERT INTO [Tble-RadiancePlus Completed WC] ( [wet clean ID], [System Number], [Customer Number], [Chamber Position], Process, [Date wc start], [Time wc start], [Wafer count], [Reason for wc], [CE wetclean complete], delay1hrs, delay2hrs, delay3hrs, delay4hrs, delay5hrs, [parts number1], [parts number2], [parts number3], [parts number4], [parts number5], [parts number6], [parts number7], [parts number8], [parts number9], [parts number10], delay1, delay2, delay3, delay4, delay5, [rework required], [reason for rework], amattimetowetclean, IBMQualTime, [target hrs] )
SELECT [WetClean ChecklistRadiancePlus].[wet clean ID], [WetClean ChecklistRadiancePlus].[System Number], [WetClean ChecklistRadiancePlus].[Customer Number], [WetClean ChecklistRadiancePlus].[Chamber Position], [WetClean ChecklistRadiancePlus].Process, [WetClean ChecklistRadiancePlus].[Date wc start], [WetClean ChecklistRadiancePlus].[Time wc start], [WetClean ChecklistRadiancePlus].[Wafer count], [WetClean ChecklistRadiancePlus].[Reason for wc], [WetClean ChecklistRadiancePlus].[CE wetclean complete], [WetClean ChecklistRadiancePlus].delay1hrs, [WetClean ChecklistRadiancePlus].delay2hrs, [WetClean ChecklistRadiancePlus].delay3hrs, [WetClean ChecklistRadiancePlus].delay4hrs, [WetClean ChecklistRadiancePlus].delay5hrs, [WetClean ChecklistRadiancePlus].[parts number1], [WetClean ChecklistRadiancePlus].[parts number2], [WetClean ChecklistRadiancePlus].[parts number3], [WetClean ChecklistRadiancePlus].[parts number4], [WetClean ChecklistRadiancePlus].[parts number5], [WetClean ChecklistRadiancePlus].[parts number6], [WetClean ChecklistRadiancePlus].[parts number7], [WetClean ChecklistRadiancePlus].[parts number8], [WetClean ChecklistRadiancePlus].[parts number9], [WetClean ChecklistRadiancePlus].[parts number10], [WetClean ChecklistRadiancePlus].delay1, [WetClean ChecklistRadiancePlus].delay2, [WetClean ChecklistRadiancePlus].delay3, [WetClean ChecklistRadiancePlus].delay4, [WetClean ChecklistRadiancePlus].delay5, [WetClean ChecklistRadiancePlus].[rework required], [WetClean ChecklistRadiancePlus].[reason for rework], [WetClean ChecklistRadiancePlus].amattimetowetclean, [WetClean ChecklistRadiancePlus].IBMQualTime, [WetClean ChecklistRadiancePlus].[target hrs]
FROM [WetClean ChecklistRadiancePlus];

 

[dcb]

Ok looks flat so

If [Tble-RadiancePlus Completed WC] [wet clean ID] is autonumber then dont insert this value!

INSERT INTO [Tble-RadiancePlus Completed WC] (  [System Number], [Customer Number], [Chamber Position], Process, [Date wc start], [Time wc start], [Wafer count], [Reason for wc], [CE wetclean complete], delay1hrs, delay2hrs, delay3hrs, delay4hrs, delay5hrs, [parts number1], [parts number2], [parts number3], [parts number4], [parts number5], [parts number6], [parts number7], [parts number8], [parts number9], [parts number10], delay1, delay2, delay3, delay4, delay5, [rework required], [reason for rework], amattimetowetclean, IBMQualTime, [target hrs] )
SELECT [WetClean ChecklistRadiancePlus].[System Number], [WetClean ChecklistRadiancePlus].[Customer Number], [WetClean ChecklistRadiancePlus].[Chamber Position], [WetClean ChecklistRadiancePlus].Process, [WetClean ChecklistRadiancePlus].[Date wc start], [WetClean ChecklistRadiancePlus].[Time wc start], [WetClean ChecklistRadiancePlus].[Wafer count], [WetClean ChecklistRadiancePlus].[Reason for wc], [WetClean ChecklistRadiancePlus].[CE wetclean complete], [WetClean ChecklistRadiancePlus].delay1hrs, [WetClean ChecklistRadiancePlus].delay2hrs, [WetClean ChecklistRadiancePlus].delay3hrs, [WetClean ChecklistRadiancePlus].delay4hrs, [WetClean ChecklistRadiancePlus].delay5hrs, [WetClean ChecklistRadiancePlus].[parts number1], [WetClean ChecklistRadiancePlus].[parts number2], [WetClean ChecklistRadiancePlus].[parts number3], [WetClean ChecklistRadiancePlus].[parts number4], [WetClean ChecklistRadiancePlus].[parts number5], [WetClean ChecklistRadiancePlus].[parts number6], [WetClean ChecklistRadiancePlus].[parts number7], [WetClean ChecklistRadiancePlus].[parts number8], [WetClean ChecklistRadiancePlus].[parts number9], [WetClean ChecklistRadiancePlus].[parts number10], [WetClean ChecklistRadiancePlus].delay1, [WetClean ChecklistRadiancePlus].delay2, [WetClean ChecklistRadiancePlus].delay3, [WetClean ChecklistRadiancePlus].delay4, [WetClean ChecklistRadiancePlus].delay5, [WetClean ChecklistRadiancePlus].[rework required], [WetClean ChecklistRadiancePlus].[reason for rework], [WetClean ChecklistRadiancePlus].amattimetowetclean, [WetClean ChecklistRadiancePlus].IBMQualTime, [WetClean ChecklistRadiancePlus].[target hrs]
FROM [WetClean ChecklistRadiancePlus];

 

[Jon123]

What I need it to do is disreguard or delete the autonumber that is in there and update it to a number that is 1 higher than the last record added.

Jon

 

[dcb]

Is [Tble-RadiancePlus Completed WC].[wet clean ID] a autonumber field?