Wanting to Group data in SQL
Folks,
From my table tblPasswords I am wanting to show the fields labeled, Applications, Comments, RoboSaved, Password where RoboSaved is Yes and only those passwords that are duplicated. The code below gives me this error:
"Your query does not include the specific expression 'Application' as part of an aggregate function"
From my table tblPasswords I am wanting to show the fields labeled, Applications, Comments, RoboSaved, Password where RoboSaved is Yes and only those passwords that are duplicated. The code below gives me this error:
"Your query does not include the specific expression 'Application' as part of an aggregate function"
SELECT tblPasswords.Application, tblPasswords.Comments, tblPasswords.RoboSaved, tblPasswords.Password, tblPasswords.Password
FROM tblPasswords
WHERE (((tblPasswords.RoboSaved)=Yes))
GROUP BY tblPasswords.Password
ORDER BY tblPasswords.Application;
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
how you define if passwords that are duplicated ?
just to remember that different IDs could have same password as well ?
just to remember that different IDs could have same password as well ?
ASKER
Ryan,
Indeed, different Applications can have the same password. Therefore I am interested in seeing only those Application when RoboSave = Yes and any passwords that are also duplicated.
ET,
I am aware of Find Duplicates and was going to explore that later.
Indeed, different Applications can have the same password. Therefore I am interested in seeing only those Application when RoboSave = Yes and any passwords that are also duplicated.
ET,
I am aware of Find Duplicates and was going to explore that later.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
May you comment on my previous comment. http:#a41388985
Duplicate on companies that was my assumption.
Duplicate on companies that was my assumption.
ASKER
I appreciated everyone's input. Hnsar, you suggested did not work but I believe points can be award for effort. Thanking you all kindly
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Thanks,
ET