Search results for query: *

Golom: it worked - this is exactly what I wanted. Thanks, I love this place!

Golom: I have got 8 tables on that remote database that the query is combining data from then doing some filtering and calculations. I guess my only option would be to link the tables from the remote database and run the query in the local database. Thanks all for your help, appreciated!

Randy: It's a dynamic database, so I need to have a live connection to it. I am thinking there must be a way of linking a query from another access database. Thanks.

Hi, Is it possible to link a query in access 2002 from another mdb access database? It gives me only tables in the menu. Thanks in advance. Max

Golom - it worked - thanks!

I've got "X7YZ_____1_State" as my State field. I guess I had to replace the Xs in your code with the field names - correct?

Golom I tried it and it worked, you are the best - thanks! :) the only problem is I get weird field names - should I replace the Xs with something else? Max

this may sound a really dumb question since I'm new to Access and relational databases - I have 3 independent tables: tblBudget_CA, tblBudget_WA, tblBudget_OR (one for each State) with identical fields each: Market, Brand, Account, Amount. I need a query that combines all three in one table with...