I have two tables with a common field:
Tbl Inv Amt
Inv_No
Inv_Amt
Tbl Cust
Inv_No
Cust_No
Cust_State
How do I create a query to give me Inv_No, Cust_No, Cust_State, Inv_Amt. I thought I could join the tables and just pull in those fields into one query from the two tables but it lists each invoice twice because it is listed in both tables - I just want to extract data from Tbl Cust. I think it may be a Lookup function but I can't figure out how to do that.
Thanks for any suggestions.
Tbl Inv Amt
Inv_No
Inv_Amt
Tbl Cust
Inv_No
Cust_No
Cust_State
How do I create a query to give me Inv_No, Cust_No, Cust_State, Inv_Amt. I thought I could join the tables and just pull in those fields into one query from the two tables but it lists each invoice twice because it is listed in both tables - I just want to extract data from Tbl Cust. I think it may be a Lookup function but I can't figure out how to do that.
Thanks for any suggestions.