Yes the worknumbers are unique and i believed 2 queries was the answer but Access keeps refusing to do it, coming up with a database violation.???
Thanks for the reply anyway.
Dale
Please help me i have 2 tables in access and 1 table has similiar information to the other one.
Eg. Table 1 Table 2
Surname Surname
Works Number First Name
Location Works Number
Locker Number Location...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.