Query Problem??

[k209310]

I have a query that replaes data in a database using the update query.

The query is called from within a VB module. Is there a way for the query to only update the first set of data? I have tried a do loop from with in the VB code however this didnt work.

The problem is in the SQL i think. Is there a way to get a query to only update one record?

 

[ColinEssex]

Hiya K - here we go again then!!! I thought we had you sorted yesterday

If you only want to update one record - you'll need to add a unique identifier to the query, like an IDNo or something to pick out just that one record.

Col

 

[k209310]

Alright colin? again! You msut be sick of me by now.
I really must learn more about Databases.

The problem with that is that i am copying a single record several times. and then changing one field.

I could add an ID collum. How would i tell the query to find a unique ID number tho?

 

[ColinEssex]

so why are you copying one record several times in the same table then?

Sorry to ask these questions but its difficult to imagine what you're doing.

You could zip the Db if you wanted.

Col

 

[k209310]

I work for a companmy that produces PEP tubes (dont ask, i dont know either) each tube in an order may have several identical parts.

The database i am working on contains the design specs (what metals are used in prodution) for the parts used.

If there is an identcial tube part that is produced say 5 times. The user of the database needs to use this same data 5 times. It is then copied the required number of times and put in to a seperate table. Each tube is then assigned a unique tube ID. (1A, 1B, 1C and so on) The letters are selected from checkboxes.

Does this make sense?

I have no problem with the inserting of data. The assigining of a tube ID works fine if i only want to add one record with one letter. The problem occurs when i come to add more than one letter. A letter is added but it adds the last letter selected by the user. eg if the user selects A and B then the tube IDS would all have B on the end. Does this make sense.

I will send you and example the Db if you think it will be any use to you. Let me know

Thanks again