Link to home
Start Free TrialLog in
Avatar of surah79
surah79

asked on

Access Query

Hi

I am trying to write an access Insert Or Append Query so that I can insert the data from one query to the Table.

The Table has the following fields
1.StageID (Autmatice Generated)
2.MonthYear(Date Time
3.FieldName
4.Field Value

The Query fields
1.Month Year
2.Total

I want to insert the Column name as well as the value and Month year(value ) in the table
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of surah79
surah79

ASKER

HI

Its giving the error unknown field name "FieldName" .

INSERT INTO Compliance ( MonthYear, FieldName, Field_Value )
SELECT ALL_CPEtransactionsanctioned.ByMonth, 'Total' AS Expr1, ALL_CPEtransactionsanctioned.Total
FROM ALL_CPEtransactionsanctioned;

Open in new window

Post the actual column names in your table.