Calculated Query fields to Table fields

[Abhean]

Hello everyone, thanks in advance.

I am working on a medical inventory Dbase where I need to separate a QR code into the needed info. I did the seperation in query
Example

GTIN: Mid([OrgUpc],3,Len([OrgUPC])-34)

So far all good.
Now I need to connect another Table to the calculated fields and running into problems at doing so. So I am hoping that I can move the calculated fields from the query into the "UPC" table via update or append?

[Seth Schrock]

An UPDATE query changes existing records. An APPEND query (aka an INSERT query) adds records to an existing table. I'm guessing that you need an INSERT query. Here is a link to instructions for how to create an INSERT query. Just put the name of your existing query in the place of table1.

[twinnyfo]

Abhean,

Weclome to Bytes!

Abhean:
Now I need to connect another Table to the calculated fields

If you need to connect another table to the calculated field, I am assuming that you mean JOIN-ing the table so that you can refer to other items in the table with the GTIN value?

You can JOIN queries to other tables just like you can join tables to each other. If I had more information about your two tables, I could provide a more detailed response.

[Abhean]

Many thanks. I found that I can simply do the calculated fields within the table w/o using a query.