Hi, I am making a database that keeps track of the wine I've enjiyed with my wife. I had one database but I've changed some things and now I have another one. I don't want to lose the data from the first one but I don't want to have to go back an forth between the 2 databases. Really I want just some basice Info from the 1st database to be added to the new one like styles and origin of the wine. So I have an accurate count of what we've had.
I want to make a Querie that will take the Origins count from my old databas and added to a table in my new database. But I also want to be able to add my new Origins to that table and keep an accurate count. For Instance if I had 10 Wines from California in my first database and 3 in my new one I want one field that gives a total of 13.

Is this possible?

Any help would be great

Thanks

First up welcome to the forum.

You should be able to massage the data from your original DB, so that you can import it into your new DB. The process for this will depend on the difference in structure between the two DB's