Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can I do this in VBA?
- Thread starter ZABADAK
- Start date
SkipVought
Programmer
ZABADAK,
If you're at the BEGINNING of the project where you can still make design changes, I would STRONGLY urge you to NORMALIZE your table.
Instead of columns M1 to M12, you ought to have a DATE column and a VALUE column.
Then at report time, using a query, you can do a crosstab to sum values across Date by month.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
If you're at the BEGINNING of the project where you can still make design changes, I would STRONGLY urge you to NORMALIZE your table.
Instead of columns M1 to M12, you ought to have a DATE column and a VALUE column.
Then at report time, using a query, you can do a crosstab to sum values across Date by month.
Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...Neopolitan Blownapart!
[/sub]- Thread starter
- #4
- Status
Similar threads
- Question
- Question
