S
Steven
I have too many records in my database and want to store
some of the history in a second database. I want to be
able to access the data in the history database and query
on certain criteria like ClientId = "?????" and Union this
with the current data from the main table in the current
database. I have a little experience with workspaces, if
that is what you use, but I do not see how to union data
from different databases and create a recordset to use as
a controlsource for a form or report.
Thank you for your help.
Steven
some of the history in a second database. I want to be
able to access the data in the history database and query
on certain criteria like ClientId = "?????" and Union this
with the current data from the main table in the current
database. I have a little experience with workspaces, if
that is what you use, but I do not see how to union data
from different databases and create a recordset to use as
a controlsource for a form or report.
Thank you for your help.
Steven