Double Entry

[ootkhopdi]

Dears

i Have a database which contains EmpId
EmpId is a Unique Id and Primary Key
I have a problem that
With this id a have some diffrent Values
like Name,Account no

I Want to search that
Which ID have Diffrent Values
and what are these Values
How Can i got

Pls help
i can't Upload this Database as exmple so it is huge

 

[Rabbie]

Please give an example of what you are trying to do. Then we may be able to help you

 

[Mihail]

Here is the DB
I also don't understand your requests.

 

[jdraw]

Mihail,

I tried opening your zip 1 and it says invalid archive.

Also,how do you understand the database? But don't understand the requests?

 

[Mihail]

Mihail, ....

I tried opening your zip 1 and it says invalid archive.
Hm.Indeed. FilZip seems to not work with spanned archives.
For now I removed half of the info from DB

Also, how do you understand the database? But don't understand the requests?
The OP has my mail address and he send me the DB.
Do you understand the request ? If YES, maybe you can translate for me.

 

[ootkhopdi]

Here is the DB
I also don't understand your requests.

the prob is
EMPID ,which is Uniuqe ID
but when i filter some ID i got diffrent Values like
two employee get Same EMPID

so i want to know how many ID having this contradiction and how can i got this

 

[Mihail]

Run this query:

SELECT ConsolidatedSalR.empid, Count(ConsolidatedSalR.EmpName) AS CountOfEmpName
FROM ConsolidatedSalR
GROUP BY ConsolidatedSalR.empid
HAVING (((Count(ConsolidatedSalR.EmpName))>1))
ORDER BY Count(ConsolidatedSalR.EmpName);

 

[ootkhopdi]

Thanks
but i think
i cant tell what is exactly prob

i want to check which id has more than one values which are diffrent not same
now i give an other example
S.No EMPID Name Month Year AC
1 1 Anil Nov 2011 123
2 2 Ashish Nov 2013 234
3 1 Ashish Dec 2013 345
4 1 Anil Nov 2011 123
5 2 Raj July 2013 456

in this u can see
s.no. 1& 4 having identical values
s.no 1& 3 having same EMPID with Different Values

now i want to know how can i get
which EMPID having different value( Ans 1 &2 )
what are these values?
how can i edit these different values as same values/
i hope now u all can understand my prob.

 

[Mihail]

Warning: This code can damage your DB
So, keep a safe copy of your DB

Import all queries and forms from this DB (see attachment) in your DB.
Run frm_1

Note that your DB has a wrong setup.
Database Normalization and Table Structures - Microsoft Access / VBA