Querys

[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

 

[John Vinson]

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

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

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.