Query import data - site table, Query import data - bin location table, Query import data – site table – IntelliTrack Check In/Out User Manual
Page 504: Query import data – bin location table, Query import data – bin location
I
NTELLI
T
RACK
C
HECK
I
N
-O
UT
V
8.1
User Manual
474
Query Import
Data – Site
Table
To transfer the imported site data into the Site table, create a select query
based on the imported data and then update the site table by running an
append query.
1.
To run a select query based on the imported site data, click Create >
Other > Query Design.
2.
A Show Table window appears; select the sites table that you created
when you imported your site data and then click the Add button. Click
Close to close the Show Table window.
3.
The Query window appears. A table window appears in the Query win-
dow.
4.
Drag the Site field to the cell in the first column of the Field row.
5.
Click the Design tab and select Results > Run.
6.
The query runs and the data in the query appears.
7.
To update the Sites table with the new data, run an append query. To
run an append query, place the window in Design View.
8.
Select Design > Append.
9.
An Append dialog appears; click the drop-down arrow in the Table
Name field and select the Sites table. Select the Current Database
option. Click OK.
10.
Select the Append To field. Place the cursor in the Append To row in
the first column of the imported field. Select the Site field from the
Sites table.
11.
Next, select Results > Run. A message appears notifying you that you
are about to append the table. To continue, click Yes. To cancel append-
ing the data, click No.
12.
Close the query; you will be prompted to save it. Save the query as
Import Sites. Click OK.
13.
Click on the Table tab.
To verify the data is in the Site table:
Select the Site table.
Click Open to view the imported data.
Query Import
Data – Bin
Location
Table
To transfer the imported location data into the bin location table, create a
select query based on the imported data and then update the bin location
table by running an append query.
1.
To run a select query based on the imported location data, click Create
> Other > Query Design.
2283.book Page 474 Thursday, July 7, 2011 2:29 PM