Now that I can run a query from one DB to another I have another problem
The DB that I have created the query in has a few fields in a table that I use to track Major Incidents. For each day there could be multiple Major Incidents. From the query I need to be able to pull in all of the major incidents for that date. Since they are in 3 different fields I would need some sort of dynamic table that combines everything. Also it wouldn't be date specific, It would need to query based on a master incident number that the data person would know. Any Ideas?
