Link to home
Start Free TrialLog in
Avatar of Steve Eckerman
Steve Eckerman

asked on

Line Item Budget SQL Statement For Access 2003

I have an attached table that has my budget line items for 2012.  I need a SQL statement that will create the AccountID, AccountNumber and Detail fields for 2013.  I need the FiscalYear field to be 2013 and the months to be zero.  Can anyone help with this?
LineItemDetail.xls
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

?
There is no 2003 data in the table...

Where is this to be used?
In Access or Excel?

If in Excel, then you can simply autoFill 2013 in all the rows you need.

Why do you want Zeros in the Month cells?

In other words, ...I'm confused....

Can you first take a step back and explain exactly what you have here and what your ultimate goal is?

...But let's see what other experts post, in case I am just not understanding something...

JeffCoachman
How about you just post the *exact* output you are looking for?
Avatar of Steve Eckerman
Steve Eckerman

ASKER

The original Excel sheet is an export from an Access 2003 database table.  The file represents our accounts for creating our companies budgeting process.  I would like an SQL  statement that would replicate the 2012 line items and create 2013 line items in the same table.  I have attached a revised Excel sheet showing the desired output that I would like appended to the original table.  I hope this helps.  Thanks!
LineItemDetail.xls
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great answer...Thanks!!!