Query returning the wrong results

[Wendyj]

I am very very new at this so please be very elementary if replying:

I have a query that is based on two tables. The Member Table has the following columns: Unit Number; Last Name; First Name; Phone Number; Move In Date and Move Out Date. The Unit Type Table has the following columns: Unit Number and Unit Type (both tables have primary keys). The Unit Number on each of the two tables is joined.

I have placed in the criteria section of Unit Number area of the query: [Which Unit]. Everything works great except when I put in 22 (for unit 22 members information) I get the information from Unit 21. I have tried changing the join type among other things and nothing seems to work. I am sure this is a very easy problem to solve but it is escaping me.

Thanks for any help you can offer

 

[dhookom]

Did you set up your table with lookup fields?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[Wendyj]

Yes I did. The Member List has a lookup for the Unit Number. The Unit Table is also limited to a list of 1 - 72 exluding 13. Wanted to do this to eliminate someone accidently putting in a non existent Unit number.

 

[dhookom]

I would immediately remove all lookup fields so you can see the values you are storing. You might want to read this

http://www.mvps.org/access/lookupfields.htm.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[Wendyj]

That did it! Thanks for the quick replies, appreciate the help!