Query to calculate difference between 2 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Table 2005 has Premium
Table 2004 has Premium
Table 2005 Premium Less Table 2004 Premium
 
EugeneZ said:
Table 2005 has Premium
Table 2004 has Premium
Table 2005 Premium Less Table 2004 Premium

We will need more information. What are the common fields or are you
just looking for a total difference?

BTW it looks like you may have a poor table design. Normally you would
not make a new table for each year, rather you would identify the year for
each entry. Of course there are exceptions to every rule.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top