Querys

  • Thread starter Thread starter Patricia
  • Start date Start date
P

Patricia

I know this is like 101 access but I do not remember.

How do I find rates in one table different from rates in
another table and show both in the result. What Critera
do I put in? What do I join?

2 tables last month and this month
First Name
Last Name
SS #
Pay Rates



Help

Thanks
 
I know this is like 101 access but I do not remember.

How do I find rates in one table different from rates in
another table and show both in the result. What Critera
do I put in? What do I join?

2 tables last month and this month
Click to expand...

well, that's a serious design flaw right there. Storing a separate
table for each month is NOT wise. Store all your rates *in the same
table* with a date field, or integer fields for Year and Month.
First Name
Last Name
SS #
Pay Rates
Click to expand...

If the SS# is a Primary Key of the table, or uniquely identifies a
record, create a Query by adding the two months' tables (or if you
take my suggestion, adding the Rates table twice). Join the two
instances by SS #. You'll now have the fields from both tables
available. With the normalized design you would add criteria to filter
each instance of the table to a desired month.
 
Back
Top