Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access 2003 query

Posted on 2016-09-06
13
Medium Priority
?
33 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

604 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