Replies

You should be able to use an append or make table query to concatenate your 10 fields into one. But I would have to ask why you want to store more than one value in a field? Example of concatenation expression.

[FieldName] & ” ” & [FieldName] & ” ” & [FieldName] & ” ” & [FieldName] & ” ” & [FieldName] etc.

Why do you want to store the same information in more than one place in the database? This could create real headaches for you down the road.

I’m not sure I follow you entirely but I wouldn’t recommend storing a calculated value in a table unless you have a very good reason – it can create havoc when deleteing and updating values that the calculation is based. Besides, you can recreate it in a query as you have. I would create a unique index of the 3 fields – that would prevent the addition of a duplicate value. Of course this would happen at the end of an update so you may want to provide a way to check for duplicates as soon as the new lot is entered. There are several ways to do this but probably the easiest is with the recordsetclone property. Take a look at the online ehpl for this property – there should be some decent examples that can point you in the right direction.

Are you updating the SQL db or reading from it? If just reading you might be able to get away with using a pass through query which would include the dsn info in the connect string.