Competent Performer
Windows 10 
Access 2016
Hi Please see below image
Query i have created
Im trying to show just unique values by Unit_ID. i tried the options under properties "Show unique values", "Show unique records" but its not working since date is difference.
As per above image i just need to show Unit_ID's 55555 & 55556 once. How to do this part?
Who is John Galt?
Windows XP Access 2007
Grouping on date (and perhaps the first fields) causes the repeats.
I only want certain values to show up on the form.
Only show numeric values
Posting Permissions
Reply With Quote