Bringout comparison of last month's data with this month's

[Guest]

This is a problem I'm losing sleep over for almost a month now. Kindly help.

In my database, I've a Customer table and an Accounts table. Customers have
Accounts. Account balances are updated every month. Accounts are grouped by
Products. I want to bring out a month-on-month comparison of Account balances
product-wise (by extension, YoY also).
I've been successful upto the part of creating databases with the Accounts
Table such as 31052006.mdb,30062006.mdb etc.
What is beyond my ability is to offer the user to select which month's data
he wants to compare, and based on the selection, to LINK to the Accounts
table in THAT database (and bring out the comparison).

 

[Alex Dybenko]

Hi,
this you can use to select file:
http://www.mvps.org/access/api/api0001.htm

and this to relink tables:
http://www.mvps.org/access/tables/tbl0009.htm

in order to compare - you can use "find unmatched records query wizard"

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

I've to mention here that Users don't have access to Database Objects and the
linking has to be done through a Form and the Code behind it.

My problem is specific to the point of "Linking" to a table in another
Database at run time. In the main Database, I've a mirror table named
"AccountsHistory" which is a copy of the Accounts table. Each time the User
selects a different Link, this table has to be filled in with data from that
ddmmyyyy.mdb table.

Hope I am clear in stating my problem.

 

[Guest]

Thanks for the quick reply.

Sorry that it created another doubt in my mind.

As advised earlier by this newsgroup, I've split my database and
implementing this module may attempt to refresh all the links, in which case,
selecting a particular table in a particular database for the "Link" needs
modding the code.Am I getting it right here ? If so,
Can you please tell me the righteous way of singling out a Link from among
the TableDefs collection ?

 

[Alex Dybenko]

Hi,
my idea was that you link 2 tables from 2 selected backends to say results1
and results2, and then run your queries based on that tables. so once you
relink sleeted backend - your reports for selected months. you can modify
code to relink you have, just build connect property based on selected
backends

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Alex,

Think I got what is required here, though it needs a lot of homework on my
part.

Thank you very much for the advice.