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!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dab4242
  • Content: Threads
  • Order by date
  1. dab4242

    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]...
  2. dab4242

    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...

Part and Inventory Search

Back
Top