Need Help with Budget Numbers from Excel to Access 2013

[rsrasc]

Hi all,

First post here so hoping I can get some help. I have the following data or table copied from Excel. Will call the below table "Base Draw", this is just an extract from over 540 records.

RouteID Mon Tue Wed Thu Fri Sat Sun ANANE002 8 14 14 14 42 0 0 ANANR001 3 3 2 2 8 0 0 ANANR002 3 3 2 2 8 0 0

I would like to set up a table in Access with a starting date of 1 Oct 2015 thru 30 Sep 2016 so the dates will be the primary column.


Here is a sample or copy of the results using the Match Index formula function in Excel, which I don't have any issues with it but would like to try this in ACCESS.

"=IFERROR(INDEX(BaseDraw!$B$2:$H$545,MATCH(E$11,Ba seDraw!$A$2:$A$545,0),MATCH($D12,BaseDraw!$B$1:$H$ 1,0)),"0")"

Date Day of The Week Week Day Info ANANE002 ANANR001 ANANR002 01-Oct-15 Thu 5 Thu 14 2 2 02-Oct-15 Fri 6 Fri 42 8 8 03-Oct-15 Sat 7 Sat - - - 04-Oct-15 Sun 1 Sun - - - 05-Oct-15 Mon 2 Mon 8 3 3 06-Oct-15 Tue 3 Tue 14 3 3 07-Oct-15 Wed 4 Wed 14 2 2 08-Oct-15 Thu 5 Thu 14 2 2 09-Oct-15 Fri 6 Fri 42 8 8

Any ideas on how to accomplish this?

Thanks in advance for any help.



Cheers!

[ItsMe]

Is it possible to import raw data relative to the Route ID into a table in Access?

tblMain
PK (Autonumber)
RouteID (Text)
SalesRepID(LongInteger)
TransactionDate(Date)