Search results

I'm using an append query to copy data from one table to another. I've noticed that values containing commas do not trigger data conversion errors if they are being written into a 'Number' field. For example, if a value such as "23,7" is written into a numbers-only field in the target table, it...

Hi, I'd really appreciate some feedback on the attached code. The code is intended to take an alphanumeric string and increment the numerical part by a specified amount e.g. the string CV01-00123 would be incremented to CV01-00124 (it's going to be used in a data input form for entering...

I've been wrestling with a design dilemma for a few days and I'd welcome some advice. I know that it is technically possible in Access to set up a relationship in which a foreign key in one table references a non-primary, but unique, indexed field in another table. I have a situation where it...

I am using the Round function in a query to display a number field in a table to 2 decimal places, but it returns a number with about 10 decimal places. Please could anyone tell me why this is? Example: In a table there is a field called 'Num' which is of number type 'Single'. A value in this...