Recent content by thurlob

answers So here is the query code from the real table. What happens is...if total query returns zeroes...because the table it's based on is empty...then the grand total (code below) returns nothing even though there is information in total-b to sum. Betsey SELECT...

clarification To clarify a little...this is not the real table, names, etc. That is confidential HR information so I had to mimic the table so you could see what I"m trying to do. No, the information is not stuffed into table 1 and table 2, it is entered manually. Just ignore the column names...

answer The query 1 and query 2 total the sum of account and sum of extended from table 1 and table 2 respectively. There is really nothing that links the two tables so I think creating a relationship would just cause confusion. Then I want a query that totals the sum of account from query 1...

answer I have two separate queries that sum the fields in the two separate tables. What I need is one query that returns a two grand totals of those two fields in the two total queries. Betsey

Grand total database I am attaching the .mdb file. This is just a sample database and it doesn't include the grand total query that I'm trying to make. If someone could just take a look and give me some ideas I would appreciate it...thanks! Sometimes the tables will have numbers in them...

So the database this user was using was made in Office 97. The query to sum two different columns in two different queries worked fine. Then we upgraded her to Office 2003 and converted the database and it no longer worked. Here is what I need to do: In total query there is a sum of account...