aggregate functions

[gsrikanth]

i need domain aggregate functions to count the occurrences of specific value in a field, and when it exceeds 1, display null. or 'group by' subqueries with count() to see if you should populate the field or not. find the attachment

link acc.accdb

i need like below

[June7]

Build a report. Use Grouping & Sorting features. Group on the D NO field. Use RunningSum property (available on reports, not forms) of textbox to produce the sequential numbering. Report textboxes also have a HideDuplicates property.

I downloaded your project. It appears to be corrupted because Access tries to repair when I open it (inconsistent state error) but fails.

[gsrikanth]

try this

link 1.mdb

[June7]

Yep, the HideDuplicates Yes gives that output. Try it.