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
Steve EckermanSystems AdministratorAsked:
Who is Participating?
 
Steve EckermanConnect With a Mentor Systems AdministratorAuthor Commented:
Thank you als315 it worked great!!!

Steve
0
 
als315Commented:
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?
0
 
Steve EckermanSystems AdministratorAuthor Commented:
Can you send me your idea in a SQL statement?

Thanks,

Steve
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
als315Commented:
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
0
 
Steve EckermanSystems AdministratorAuthor Commented:
Here is the table in Excel format.

Thanks,

Steve
PartForecast.xls
0
 
Steve EckermanSystems AdministratorAuthor Commented:
Basically I just want to copy the 2016 records to the same table and change the fiscal year to 2017.

Thanks,

Steve
0
 
als315Commented:
Look at sample (you can remove some columns if you will refill them with new data)
DB2016.mdb
0
 
Steve EckermanSystems AdministratorAuthor Commented:
All your query did was double the 2016 records.
0
 
aikimarkCommented:
I think you will need to push the rows from the newer database, since the 2003 database doesn't understand the 2007+ format.
0
 
Steve EckermanSystems AdministratorAuthor Commented:
I can only use Access 2003 because my system is programmed before .NET came into affect.

:(
0
 
als315Connect With a Mentor Commented:
Sorry, my mistake
DB2016.mdb
0
 
aikimarkCommented:
My bad.  My initial read of the problem caused me to think that you were dealing with multiple Access versions.
0
 
Steve EckermanSystems AdministratorAuthor Commented:
The query als315 provided accomplished what I was trying to do.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.