I currently have a query that runs a start date and end date in it for numbers on testing. Trying to see if there is a way to restrict it to where I only get one record per CACID(different field) for that date period. I cant figure a way to do it.
I currently have a query that runs a start date and end date in it for numbers on testing. Trying to see if there is a way to restrict it to where I only get one record per CACID(different field) for that date period. I cant figure a way to do it.
Really hard to give a good answer without seeing the query, but if you have parameters for the two dates AND the CACID field, switch to SQL view and add the "TOP" predicate. It might look something like:
"SELECT TOP 1 Date1, Date2, ....."
Check out Allen Browne's Top N Records Per Group at http://allenbrowne.com/subquery-01.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.