Jeff,
There are ~6,000 records.
The first four columns are always the same. The next 24 roll so that col E becomes "Apr-15" next mo, "Mar-15" moves from col E to F, and "Apr-14" drops off. The reason why there are 24 is that there are 12 for revenue and 12 for number of transactions. The column heads for transactions have the same column heads as for revenue; e.g., "Mar-15" is the head for columns E and R. These are actually in row 2. Row 1 has "Revenue" and "Transactions" across the top of their respective 12 columns. There are also some fixed columns to the right.
The table I put them in has field names "Rev1" "Rev2" ... "Rev`12" "Tran1" "Tran2" ... "Tran12" with 1 representing the most recent month, 2 the prior, etc. I manually enter the report month which then drives the column headers in forms and reports.
I don't need to save any history. I delete prior data and import a new set of data each month.
What's the advantage of doing the automation in and pushing it up from Excel rather than from Access? All the other work and reporting is done in Access.
Adam
Posted by: runuphillracing@yahoo.com
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar