Search results

I have a main data entry form--- it contains a bound text field to enter case numbers-- The Case Number will always start with a number '2', or a number '0'--- IF the user enters the first digit '2', then that digit will ALWAYS be followed by 8 zeros--- Typical Case numbers: 20000000123456 or...

In trying to assist another member, I created a simple setup. tblValues has one field named 'Value', which holds 3 random text records, each containing one or more strings separated by a comma and a space. Value 434534 3454534, 7888, 44fxcew, eqeew ewrqw, 5643, art4345, 32af The Function...

I need to create a simple query that selects a few fields from a table, and appends them to another table. No big deal, right? INSERT INTO Table2 ( FieldOne, FieldTwo ) SELECT Table1.FieldOne, Table1.FieldTwo FROM Table1; BUT, I also need to append values into a third field that just number...