Jul. 2nd, 2004 10:46 am
Access nonsense
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
andysocialDoes anyone know a lot of Access/SQL tricks? I manage the databases at work, but don't have any particular training beyond hitting F1. Well, the installation I'm stuck with is not one I'd prefer, but it is what it is.
I have to maintain two databases with identical structures but different data. How can I make a query that will provide me a unified view of the data, in a third "front-end" database? I know it must be possible, but I can't figure it out. The SQL JOIN command sounded like a good avenue of investigation, but doesn't look right for this. I need to be able to create a fake append, more or less, without modifying the data in the tables themselves.
An example: I've got two tables with lesson data (when it was assigned, completed, etc.) but I want to output one report at the end of the month on what was accomplished by everyone. I know, I should just leave everything in one database instead of two. I don't have a choice. I know, I should use something more powerful than MS Access. I don't have a choice.
Any help would be appreciated.
*Update* I convinced them to go with a sane configuration, and we'll be going to one database with an optional field.
I have to maintain two databases with identical structures but different data. How can I make a query that will provide me a unified view of the data, in a third "front-end" database? I know it must be possible, but I can't figure it out. The SQL JOIN command sounded like a good avenue of investigation, but doesn't look right for this. I need to be able to create a fake append, more or less, without modifying the data in the tables themselves.
An example: I've got two tables with lesson data (when it was assigned, completed, etc.) but I want to output one report at the end of the month on what was accomplished by everyone. I know, I should just leave everything in one database instead of two. I don't have a choice. I know, I should use something more powerful than MS Access. I don't have a choice.
Any help would be appreciated.
*Update* I convinced them to go with a sane configuration, and we'll be going to one database with an optional field.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
no subject