distinctrow did not work but I do have multiple entrioes in teh table. After looking at the report I have decided to hide multiples but not all fields. thank you for all the help
Below is the code for my cmdOK box in a form called Password. I have a tbl called Security that Password reads the username and password from to validate. In the form I have two text fields called Username and Password and 2 cmd buttons called cmdOK and cmdCancel. In the table there are 3...
Below is my SQL statement for a report I have. I added the DISTINCT so that when it finds a duplicate entrie but it still does not work. Can someone help with this PLEASE.
SELECT DISTINCT [tblEnduser].[EU_EID], [tblEnduser].[EU_NAME], [tblEnduser].[EU_Phone], [tblEnduser].[tblroom]...
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.