P
Phill
Hi:
First, I would like to thank you for taking the time to help me with my problem and secondly a little about my problems.
I have about 10 databases that I would like to run a query off of. So in one database the query would pull info from the external databases. At a minimum the results would show, the sponsors name what department they are receiving founding from, Federal Id (key) and whether or not they are still in contract. The contract time period varies from dept. to dept. So there would have to be some sort of date expr. or function.
I tried to do it in SQL; but to no supprise it did not work. that was my first time doing SQL by the way.
My other problem that might be a whole lot eaier is that I have an append query that I would like to run every 15 or whatever of the month. By itself( no human intervention) and have it print.
Again thank you and if you need more info just write to me at my email.
First, I would like to thank you for taking the time to help me with my problem and secondly a little about my problems.
I have about 10 databases that I would like to run a query off of. So in one database the query would pull info from the external databases. At a minimum the results would show, the sponsors name what department they are receiving founding from, Federal Id (key) and whether or not they are still in contract. The contract time period varies from dept. to dept. So there would have to be some sort of date expr. or function.
I tried to do it in SQL; but to no supprise it did not work. that was my first time doing SQL by the way.
My other problem that might be a whole lot eaier is that I have an append query that I would like to run every 15 or whatever of the month. By itself( no human intervention) and have it print.
Again thank you and if you need more info just write to me at my email.