Displaying fields from a query in one database in a query in another

[tweeterbot]

I am using Access 2000 in Windows XP.

I am designing a database that needs to have YTD calculations based on values from previous months. The problem is that these values are calculated in queries in that particular months' database.

I have experimented with simply importing what I need as a table and then querying the value in that table. While this would work and it is what I will do if I can't figure out an alternative, what I would really like to do is find a way to include these fields in such a way that they would automatically update if anything in the previous database (where they came from) is updated. Any thoughts?

Thanks,
Rachel

[missinglinq]

Just to be clear here, as you saying that you actually have a separate database (.MDB file) for each month?

Welcome to TheScrips!

Linq ;0)>

[tweeterbot]

Just to be clear here, as you saying that you actually have a separate database (.MDB file) for each month?

Welcome to TheScrips!

Linq ;0)>

Yes, that is what I'm trying to do right now. Do you think that's smart, or do you think I should try to find a way to get it all in one given that these calculations operate on the same set of pricing, targeting, and correlating tables with just different data inputs?

I know that's not a lot to go on for a question like that. I guess what I'm asking more generally is: knowing that I have information in both tables and queries that I want to carry from one month to the next, is it advisable to try to split it up (by month) at all? At this point I am very open to suggestions.

Thanks,
Rachel