Hello,
We use an Access db. This db has to be archived regularly. On archive all but current - ie active records are seemingly deleted(they are stored on file as a .xls)
I need to report on old and current data, so that i can report on things such as YTD V LYTD, count(*) of all jobs etc.
Can i connect crystal to the current AND archive dbs to list all the data i need. - they would be exactly he same tables, columns and joins.
If not, has anyone any ideas that may be of help.
Thanks in advance.
We use an Access db. This db has to be archived regularly. On archive all but current - ie active records are seemingly deleted(they are stored on file as a .xls)
I need to report on old and current data, so that i can report on things such as YTD V LYTD, count(*) of all jobs etc.
Can i connect crystal to the current AND archive dbs to list all the data i need. - they would be exactly he same tables, columns and joins.
If not, has anyone any ideas that may be of help.
Thanks in advance.