Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dab4242
-
MS Access "Undefined function 'distinct' in expression
Thanks for the quick response! Is Access powered by Jet SQL? I thought I had used this syntax before in Access. If it will not support the Count(Distinct) systax any suggesstions on how to return the same values? Dan- dab4242
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
MS Access "Undefined function 'distinct' in expression
Hey Guys- Any help with this one would me much appreciated. I am trying to run the following query and receive this error message "Undefined function 'distinct' in expression" SELECT [Non Par].[Provider Name], [Non Par].[Provider #], Sum([Non Par].[Claimed Amt]) AS [Sum Of Claimed Amt]...- dab4242
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
For Loop Range Referencing Macro
Thanks Skip!!! I'm always making things more difficult than they need to be. Dan- dab4242
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
For Loop Range Referencing Macro
Hi Guys- Any help would be much appreciated. I have a range of data (names) that I am trying to loop through and delete any instances where the name is repeating. Here is what I have so far. Sub RemoveDuplicates() Dim c As Range Dim d As Range Dim a, b, y, x, z, NewVal For Each c In...- dab4242
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
