Make-table query? - 2 parts of the problem...

[tinkertoy]

This a two part problem -

I have a ODBC link table that I am making another table from with a make-table query. The new table has some slightly different requirements. This table is to be based on the requirements that an application needs to run it, the data from that table will be export to a delimited text/dat file for the application (I know kind of going backwards - until the original application is replaced, have to do it this way)

Problems:

1. In query I am only using a few fields from the original table - but, here is the problem, I need an additional field in the new table, that should remain a constant, this field is not in the original table, or any other table at this time.
New table - new field



2. The second ID number field has 6 digits in it in the original table. In the new table I want that field to only show that last 3 digits.
Original Table - Field - Code - 123450
New Table - Field - Code - 450
I know that I will have to do some sort of criteria about the left right part and can do this in the VB code, but haven't done it in the query criteria.

I already know about changing the names from one field to the new table/field. And, what fields need to be exported, that has already been mapped out. I have a feeling I will have to create a table and have the extra field in it, and the field that joins it to the original table, before creating the query.

Is this a make-table query or append or update? I am stumped on these. Any suggestions?



tinkertoy

 

[tinkertoy]

I wanted to add to this:

Some of the new fields are "filler"s, with a "0" in each. Another one should a number in it that is matched to a specific code.