ConcatRelated Count in a report (1 Viewer)

[iaasiqbal]

Dear sir
I have a database of locker inventory. (All, rented & unrented category) . In a report I can count total as all ,but cant not counted rented and un rented column . please help in this regards . i have uploaded db here

 

[Eugene-LS]

I have a database of locker inventory. (All, rented & unrented category) . In a report I can count total as all ,but cant not counted rented and un rented column . please help in this regards . i have uploaded db here

The solution depends entirely on the structure of your data, which we can't see in the picture.
Please post your application (or part of it) on the forum.

 

[theDBguy]

Hi. Welcome to AWF!

Lots of options for you. Which one to use depends on your setup. You could try using DCount() too.

 

[iaasiqbal]

The solution depends entirely on the structure of your data, which we can't see in the picture.
Please post your application (or part of it) on the forum.

my db here

 

[Eugene-LS]

my db here

ALL LOCKER:

=DCount("LockerNo";"qrall";"BranchName=""" & [BranchName] & """ and LockerSize='" & [LockerSize] & "'")

RENTED LOCKER:

=DCount("LockerNo";"qrall";"BranchName=""" & [BranchName] & """ and LockerSize='" & [LockerSize] & "' AND Rented = True")

UN-RENTED LOCKER:

=DCount("LockerNo";"qrall";"BranchName=""" & [BranchName] & """ and LockerSize='" & [LockerSize] & "' AND Rented = False")

See to "tx" report ...

 

[arnelgp]

will only work on Print Preview.

 

[iaasiqbal]

ALL LOCKER:

=DCount("LockerNo";"qrall";"BranchName=""" & [BranchName] & """ and LockerSize='" & [LockerSize] & "'")

RENTED LOCKER:

=DCount("LockerNo";"qrall";"BranchName=""" & [BranchName] & """ and LockerSize='" & [LockerSize] & "' AND Rented = True")

UN-RENTED LOCKER:

=DCount("LockerNo";"qrall";"BranchName=""" & [BranchName] & """ and LockerSize='" & [LockerSize] & "' AND Rented = False")

See to "tx" report ...

thanks a lot , it is working fine , thanks again