Help please I have table with two key fields varUser and varProperty - I am trying to count varProperty within a distinct varUser query to count varPropeerty only once for each user. SQL not my strongpoint and I can get a distinct or a count but not both.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.