Solved

Access 2003 query

Posted on 2016-09-06
13
30 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

738 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