469,628 Members | 1,044 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,628 developers. It's quick & easy.

Consolidating Data

G'day

I have two tables with transactional data. Table 1 has a Cost Centre,
Account, Fund Code and a YTD0-6 figure for each Account Number. Table 2

has Cost Centre, Account, Fund Code, Period 7, Period 8, Period 9,
Period 10, Period 11, Period 12 data.

Both Tables are linked to 'Data Tables' , Account Information, Cost
Centres Information and Fund Type Information.
What I want is to consoldiate the transactional data into one table so
that it would look something like this:
YTD0-6 Period7 Period8
etc
Account Cost Centre Fund type
I have designed a query to consolidate the data, but for some reason
the query duplicates the records. Is there some way around this.
Thanks for your assistance.
Greg

Apr 20 '06 #1
2 1727
How about posting the SQL statement?

BTW, you do realize this is seriously denormalized, right? Any reason
why you don't want a structure like:

Transaction(CostCentre, Account, FundCode, PeriodID, Value)

That would make your querying easier.

Apr 21 '06 #2

pietlin...@hotmail.com wrote:
How about posting the SQL statement? Can you program SQL in Access? I wouldn't classify myself as an Access
Power User
BTW, you do realize this is seriously denormalized, right? Any reason
why you don't want a structure like:

Transaction(CostCentre, Account, FundCode, PeriodID, Value) Period ID/Value are one in the same
That would make your querying easier.


Apr 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by David | last post: by
6 posts views Thread by imani_technology_spam | last post: by
1 post views Thread by None | last post: by
reply views Thread by NicK chlam via DotNetMonster.com | last post: by
1 post views Thread by Monkey Boy | last post: by
7 posts views Thread by NoviceProgramer | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.