Query --> Populate table, keep table parameters

[Jeff]

Hi,

I have a select query that is linked to an ODBC database.
Each month we have to take the results of the select query and put this into
excel.

Our query has 3 columns: Date; Account Number; Fund Value

The problem is that each month the number of account values change and when
this is paste into excel the table also changes.

Usually the results of the query is 30 rows and 3 columns, but sometimes
this changes.

So, if account # "XYZ" is not there it will not be returned by the query.
How do we keep the table the same and have account "XYZ" return zero account
balance?

THanks!

 

[KARL DEWEY]

Create a totals query to pull all account numbers and use it in a left join
query.

 

[John W. Vinson]

Hi,

I have a select query that is linked to an ODBC database.
Each month we have to take the results of the select query and put this into
excel.

Our query has 3 columns: Date; Account Number; Fund Value

The problem is that each month the number of account values change and when
this is paste into excel the table also changes.

Usually the results of the query is 30 rows and 3 columns, but sometimes
this changes.

So, if account # "XYZ" is not there it will not be returned by the query.
How do we keep the table the same and have account "XYZ" return zero account
balance?

THanks!

What table is the basis of this query? Do you have some other table which has
all of the accounts, even those with zero balance? If so you could use a Join
to connect the static accounts table to this variable table... and thereby see
all accounts.

 

[Jeff]

I see now, create an accounts table and just link it to the main ODBC table.

Thanks a lot!