Solved Dcount

[mdshuja]

Hi

I am using count function to bring total count of particular Customer ID, Count: [Polnumber] & "/" & DCount("*","CommissionDetail","[Polnumber]='" & [PolNumber] & "'"), i got perfect result XXXXXX/9 OR XXXXXX/10 OR XXXXXXX/12
I am looking XXXXXX/1 of 1, XXXXXX/1 of 2, XXXXXX/1 of 3 etc.,
or XXXXXX/1 of 9, XXXXXX/2 of 9, XXXXXX/3 of 9 etc.,

kindly help

Thanks
Shuja.

 

[Eugene-LS]

Count: [Polnumber] & "/" & DCount("*";"CommissionDetail";"[Polnumber]='" & [Polnumber] & "'")-DCount("*";"CommissionDetail";"[Polnumber]='" & [Polnumber] & "' AND [Your RECORD ID FIELD]>" & [Your RECORD ID FIELD]) & " of " & DCount("*";"CommissionDetail";"[Polnumber]='" & [Polnumber] & "'")
or

... [Polnumber] & "/" & DCount("*","CommissionDetail","[Polnumber]='" & [smdFirstName] & "'")
-DCount("*","CommissionDetail","[Polnumber]='" & [Polnumber] & "' AND [Your RECORD ID FIELD]>" & 
[Your RECORD ID FIELD]) & " of " & 
DCount("*","CommissionDetail","[Polnumber]='" & [Polnumber] & "'") AS TCount ...

Change "Your RECORD ID FIELD" to your name of field.
Beter sort order: [Polnumber], [Your RECORD ID FIELD]

 

[mdshuja]

Count: [Polnumber] & "/" & DCount("*";"CommissionDetail";"[Polnumber]='" & [Polnumber] & "'")-DCount("*";"CommissionDetail";"[Polnumber]='" & [Polnumber] & "' AND [Your RECORD ID FIELD]>" & [Your RECORD ID FIELD]) & " of " & DCount("*";"CommissionDetail";"[Polnumber]='" & [Polnumber] & "'")
or

... [Polnumber] & "/" & DCount("*","CommissionDetail","[Polnumber]='" & [smdFirstName] & "'")
-DCount("*","CommissionDetail","[Polnumber]='" & [Polnumber] & "' AND [Your RECORD ID FIELD]>" &
[Your RECORD ID FIELD]) & " of " &
DCount("*","CommissionDetail","[Polnumber]='" & [Polnumber] & "'") AS TCount ...

Change "Your RECORD ID FIELD" to your name of field.
Beter sort order: [Polnumber], [Your RECORD ID FIELD]

Thanks for your reply,

Sql & Function is not working, i have attached Access File, If possible Please update in Access,

is it possible to create Unique ID Column in Tables should calculate count formulas and store in the Unique ID Column

Thanks

 

[Eugene-LS]

Sql & Function is not working,

I have added a key field to your table

 

[mdshuja]

Thanks for your reply,

Sql & Function is not working, i have attached Access File, If possible Please update in Access,

is it possible to create Unique ID Column in Tables should calculate count formulas and store in the Unique ID Column

Thanks

Amazing, It's Working Thanks a lot.