Query sales anlaysis

[cboland]

Good afternoon

I have two tables - sales 2004 and 2005 - both showing account number, product, quantity, sales and margin. When I link account number and try to show both years the results are incorrect.....I know I am doing something wrong!! I have tried creating new table with blank fields for 2005 basing the table on 2004 and then updating 2005 - but no go.....

Help please

Many thanks

Catherine

 

[Matt Greatorex]

Are all of the account numbers unique? If so, that would produce a blank query, since there wouldn't be any 'common' values between the two tables, on which to link.

If not, what do the structures of the tables and query actually look like?

 

[cboland]

struggling with queries

Are all of the account numbers unique? If so, that would produce a blank query, since there wouldn't be any 'common' values between the two tables, on which to link.

If not, what do the structures of the tables and query actually look like?

Hi Matt - thanks for reply - the account numbers are common and the tables look like the attached extract - (copied from two tables into spreadsheet)

when I created an update table - to take the values from one table and add them to blank fields created in 2nd table - the query tried to update 190000 fields - when there are only 9800 records.....

Any ideas.....

many thanks

 

[StevenS]

Please show the queries/SQL you used

 

[Rich]

Why are you creating a separate table for each year?