Solved

Access 2003 query

Posted on 2016-09-06
13
27 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
  • 7
  • 4
  • 2
13 Comments
 
LVL 39

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 39

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
 

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 39

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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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 39

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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: …

895 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now