?
Solved

Access 2003 query

Posted on 2016-09-06
13
Medium Priority
?
32 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
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 

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 46

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 2000 total points
ID: 41786395
Sorry, my mistake
DB2016.mdb
0
 
LVL 46

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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
New style of hardware planning for Microsoft Exchange server.
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: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 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