Solved

Access 2003 query

Posted on 2016-09-06
13
31 Views
Last Modified: 2016-09-11
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
0
Comment
Question by:submarinerssbn731
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
  • 2
13 Comments
 
LVL 40

Expert Comment

by:als315
ID: 41786287
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
 

Author Comment

by:submarinerssbn731
ID: 41786311
Can you send me your idea in a SQL statement?

Thanks,

Steve
0
 
LVL 40

Expert Comment

by:als315
ID: 41786329
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
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

 

Author Comment

by:submarinerssbn731
ID: 41786340
Here is the table in Excel format.

Thanks,

Steve
PartForecast.xls
0
 

Author Comment

by:submarinerssbn731
ID: 41786343
Basically I just want to copy the 2016 records to the same table and change the fiscal year to 2017.

Thanks,

Steve
0
 
LVL 40

Expert Comment

by:als315
ID: 41786349
Look at sample (you can remove some columns if you will refill them with new data)
DB2016.mdb
0
 

Author Comment

by:submarinerssbn731
ID: 41786364
All your query did was double the 2016 records.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 41786382
I think you will need to push the rows from the newer database, since the 2003 database doesn't understand the 2007+ format.
0
 

Author Comment

by:submarinerssbn731
ID: 41786386
I can only use Access 2003 because my system is programmed before .NET came into affect.

:(
0
 
LVL 40

Assisted Solution

by:als315
als315 earned 500 total points
ID: 41786395
Sorry, my mistake
DB2016.mdb
0
 
LVL 45

Expert Comment

by:aikimark
ID: 41786426
My bad.  My initial read of the problem caused me to think that you were dealing with multiple Access versions.
0
 

Accepted Solution

by:
submarinerssbn731 earned 0 total points
ID: 41786543
Thank you als315 it worked great!!!

Steve
0
 

Author Closing Comment

by:submarinerssbn731
ID: 41793237
The query als315 provided accomplished what I was trying to do.
0

Featured Post

More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question