molsonbubba,
Here is what the good people are telling you.
molsonbubba said:
The Fields are actually Columns in my table. Sorry if I messlead you.
Believe me when I tell you that they understand that column=field for this purpose.
molsonbubba said:
The info in the Column 1 is static text that is set as default for each record.
If the info in column 1 is ALWAYS EXACTLY the same, unchanging value (e.g. "Apple" or 45, as opposed to the date the record was entered (which could be set up to be a default value for the field)) for each and every record in the table, and is NEVER different OR absent for any record, there is no (good) reason to store this data (whatever it is) repeatedly (for every row in your table). You would achieve the same result by writing a query to provide this effect.
e.g:-
SELECT "Apple" AS Field1, YourTableName.Field2, YourTableName.Field3
FROM YourTableName;
This query would create the appearance that "Apple" was stored with each and every record, without actually having to store it (which would unnecessarily take up database space so is not good practice).
molsonbubba said:
The Coumn 2 is numeric and different and unique for each record. I believe I would need to concatenate Column 1 and 2
Yes, you can concatenate the fields, as Pat said, in a query - refer Pat's post for how to do that.
Assuming you are happy to eliminate the first field, field3 really becomes:- somethingstatic & Field2
Your query would then look like
SELECT "Apple" & [Field2] AS YourConcatenatedFieldName
FROM YourTableName;
molsonbubba said:
...and result would be entered into Column 3. But how do I write the query?
If column 3 is "a function of" columns 1 and 2, (or static data and column2) good database design practice would discourage you from storing this "result" in field 3 (in the table), again as it would unnecessarily take up space. Instead, simply create a query that performs this calculation (as above), and use it in place of using the table, when you want that result. This would give you your field3 without "entering" it (storing it) in the table.
Generally speaking, the people here have BUCKET loads of experience and could very simply tell you how to do exactly what you have asked, but instead they are offering you the help that you
aren't asking for, because they know there are good reasons NOT to do what you say you want to do, and they are helping you to "do it right" in the first instance. This will serve you better in the long run.
Be brave and strong. Benefit from their knowledge and wisdom.
Hope this explains things.
Regards
John.
