I'm having a problem with a SQL statment. I've got two tables:
Table Stage:
Location Date Sales Exp Tax
NewYork 1/1/01 100.50 5.75 11.25
and so on with about 20 account columns.
I want to move this data into another table like this:
Table PlanData:
Location Date Account Amount
NewYork 1/1/01 Sales 100.50
NewYork 1/1//01 Exp 5.75
NewYork 1/1/01 Tax 11.25
Here's my statement:
INSERT INTO PlanData (Location, Date, Account, Amount)
SELECT Location, Date, "Sales" AS Account, Sales
FROM Stage
This is executing but I'm getting an integer into Column 3 in my
PlanData table and the value in the amount table, like this:
NewYork 1/1/01 100 100.50
Can anyone help? I'm a newb so I'm sure it's a stupid error on my
part.