By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Calculated Query fields to Table fields

P: 12
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
Expand|Select|Wrap|Line Numbers
  1. 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?
2 Weeks Ago #1

✓ answered by 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.

Share this Question
Share on Google+
3 Replies


Seth Schrock
Expert 2.5K+
P: 2,931
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.
2 Weeks Ago #2

twinnyfo
Expert Mod 2.5K+
P: 3,054
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.
2 Weeks Ago #3

P: 12
Many thanks. I found that I can simply do the calculated fields within the table w/o using a query.
2 Weeks Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.