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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Post the actual column names in your table.
ASKER
Its giving the error unknown field name "FieldName" .
Open in new window