asked on
Access 2003 query
I have a table called the PartForecast. I would like a query that copies the 2016 records to the PartForecast table as 2017 records. Can anyone give me some direction on this query?
Thanks in advance,
Steve
Thanks in advance,
Steve
Microsoft OfficeMicrosoft AccessSQL
Last Comment
Steve Eckerman
Make append query with same source and resulting table - PartForecast and change date field from 2016 to 2017. May be you can upload sample DB with this table only and some dummy data?
ASKER
Can you send me your idea in a SQL statement?
Thanks,
Steve
Thanks,
Steve
I need structure of your table. What is in field with Year?
Look at query qry1. 1 is added to year number. If you have more then one year in the table, you can add criteria
DB2016.mdb
Look at query qry1. 1 is added to year number. If you have more then one year in the table, you can add criteria
DB2016.mdb
ASKER
ASKER
Basically I just want to copy the 2016 records to the same table and change the fiscal year to 2017.
Thanks,
Steve
Thanks,
Steve
Look at sample (you can remove some columns if you will refill them with new data)
DB2016.mdb
DB2016.mdb
ASKER
All your query did was double the 2016 records.
I think you will need to push the rows from the newer database, since the 2003 database doesn't understand the 2007+ format.
ASKER
I can only use Access 2003 because my system is programmed before .NET came into affect.
:(
:(
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
My bad. My initial read of the problem caused me to think that you were dealing with multiple Access versions.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
The query als315 provided accomplished what I was trying to do.