Solved

MS Access 2003 Query

Posted on 2016-09-29
2
58 Views
Last Modified: 2016-09-29
I have a table called LineItemDetail in Access 2003.  I want to copy the Fiscal Year 2016 records back into the LineItemDetail table with a set of records that now have 2017 in the Fiscal Year column.
LineItemDetail.xls
0
Comment
Question by:submarinerssbn731
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 41822107
You can try this query:
INSERT INTO LineItemDetail ( AccountID, AccountNumber, Detail, Jan, Feb, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, [Dec], Updatedate, FiscalYear )
SELECT LineItemDetail.AccountID, LineItemDetail.AccountNumber, LineItemDetail.Detail, LineItemDetail.Jan, LineItemDetail.Feb, LineItemDetail.Apr, LineItemDetail.May, LineItemDetail.Jun, LineItemDetail.Jul, LineItemDetail.Aug, LineItemDetail.Sep, LineItemDetail.Oct, LineItemDetail.Nov, LineItemDetail.Dec, LineItemDetail.Updatedate, 2017 AS FiscalYear
FROM LineItemDetail
WHERE (((LineItemDetail.FiscalYear)=2016));

Open in new window

0
 

Author Closing Comment

by:submarinerssbn731
ID: 41822138
Thanks again!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can I Flash a mandatory field in Access Form? 13 46
SYbase 4 28
Querying data from 3 SQL tables 2 31
Criteria for Date for DCount 4 17
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

776 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