Problem with quering

B

Belle

I have created a query based on 5 vother query/tables. I am trying to
calculate the total cost over the 5 tables/queries. I am getting a blank
reslut page because the query is looking for each table to have the same
project name before giving me a result. In some cases the will not be an
entry for the project name on some queries/tables because nothing was chosen.
But anywho, how can I calculate a value over several tables but not having
them related?
 
T

Tom Wickerath

..... because the query is looking for each table to
have the same project name before giving me a result.
Click to expand...
Huh? Please explain what you mean by a table having a project name....
But anywho, how can I calculate a value over several
tables but not having them related?
Click to expand...
Not sure why you have several tables without having them related. Access is a relational database
product, after all. It sounds like you may have a serious design issue going on here. However, to
answer your question, you can create a union query that includes the same number of fields drawn
from each table, as long as the datatypes for each field are the same. This will allow you to
select the appropriate records. You can then create a new query that uses the union query as it's
source, and performs the totaling operation.

Tom
_____________________________


I have created a query based on 5 vother query/tables. I am trying to
calculate the total cost over the 5 tables/queries. I am getting a blank
result page because the query is looking for each table to have the same
project name before giving me a result. In some cases the will not be an
entry for the project name on some queries/tables because nothing was chosen.
But anywho, how can I calculate a value over several tables but not having
them related?
 
Top