FORMAT THE DATA TO ONE FEILD???????

  • Thread starter Thread starter Lanny
  • Start date Start date
L

Lanny

How can I change my data to be imported into another database? I am using
2003 software
My columns on my own database have an individual field for each quanity.

Qty 1
Qty 2
Qty 3

The database I need the data to be imported too uses,

Qty 1 / Qty 2 /Qty 3 all in one field.

Is there a way I can group my quanities in one field so they can import the
data to their database?
 
If I understand correctly you need to use a union query like:
SELECT FieldA, FieldB, [Qty 1] As Qty, 1 as QtyNum
FROM tblNoNameGiven
UNION ALL
SELECT FieldA, FieldB, [Qty 2], 2
FROM tblNoNameGiven
UNION ALL
SELECT FieldA, FieldB, [Qty 3], 3
FROM tblNoNameGiven;
 
Sorry Duane I guess I did not explain myself correctly. The Qty is only one
column and is grouped by a Claim number then a Squawk number and then a Line
number. Each Qty is the amount of parts on each individual
claim/squawk/line. The database I want to load this to just has claim/squawk
and then all the lines are grouped as one. I just need to be able to show
all of the QTY's in one feild for each claim/Squawk.

Duane Hookom said:
If I understand correctly you need to use a union query like:
SELECT FieldA, FieldB, [Qty 1] As Qty, 1 as QtyNum
FROM tblNoNameGiven
UNION ALL
SELECT FieldA, FieldB, [Qty 2], 2
FROM tblNoNameGiven
UNION ALL
SELECT FieldA, FieldB, [Qty 3], 3
FROM tblNoNameGiven;

--
Duane Hookom
Microsoft Access MVP


Lanny said:
How can I change my data to be imported into another database? I am using
2003 software
My columns on my own database have an individual field for each quanity.

Qty 1
Qty 2
Qty 3

The database I need the data to be imported too uses,

Qty 1 / Qty 2 /Qty 3 all in one field.

Is there a way I can group my quanities in one field so they can import the
data to their database?
Click to expand...
Click to expand...
 
Back
Top