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
LineItemDetail.xls
How about you just post the *exact* output you are looking for?
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
LineItemDetail.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great answer...Thanks!!!
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