Reports (1 Viewer)

Samerkh

New member
Local time
Today, 23:22
Joined
May 26, 2021
Messages
2
hey guys, is there any code to put on the text box near Missing Numbers and Duplicates Numbers to give me those results ?
i wrote those numbers in red manually just to give an example.
the idea is just to loop through CityID field and know if there's duplicates or missing numbers without a query. just in vba . because this report is based on selected or filter records in a subform. but i failed to wrote a code
 

Attachments

  • 32443.PNG
    32443.PNG
    12.4 KB · Views: 102

theDBguy

I’m here to help
Staff member
Local time
Today, 13:22
Joined
Oct 29, 2018
Messages
21,467
Hi. Welcome to AWF!

Did you mark this thread as "solved" because you already managed to figure it out?
 
Last edited:

Samerkh

New member
Local time
Today, 23:22
Joined
May 26, 2021
Messages
2
Hi. Welcome to AWF!

Did you mark this thread as "solved" because you already managed to figure it out?
No it's not solved sorry, miss clicked.
And ty
 
Last edited by a moderator:

theDBguy

I’m here to help
Staff member
Local time
Today, 13:22
Joined
Oct 29, 2018
Messages
21,467
No it's not solved sorry, miss clicked.
And ty
In that case, can you post a sample copy of your db to help us figure out your request? Thanks!
 

Users who are viewing this thread

Top Bottom