DCount?

[bw]

My SQL Code is as follows:

SELECT tblBillSeats.BankName, tblBillSeats.BPseats, tblBillSeats.Pamt,
tblBillSeats.BTseats, tblBillSeats.Tamt, tblBillSeats.BType
FROM tblBanks INNER JOIN tblBillSeats ON tblBanks.BankName =
tblBillSeats.BankName
GROUP BY tblBillSeats.BankName, tblBillSeats.BPseats, tblBillSeats.Pamt,
tblBillSeats.BTseats, tblBillSeats.Tamt, tblBillSeats.BType;

1. I want to know how many values of BType are True, and how many are
False for each BankName.

2. I want to know how many BTypes there are for each BankName.

While I'm sure DCount is what to use here, I can't get anything to work.

This is giving me a syntax error:

CountTrue: DCount("[BillSeatsID]","[tblBillSeats]","[BType] = True and
[tblBillSeats]![BankName] = " & [tblBillSeats]![BankName])

 

[Ken Snell \(MVP\)]

Assuming that BankName field is a text field:

CountTrue: DCount("*","[tblBillSeats]","[BType] = True and
[BankName] = '" & [BankName] & "'")

 

[bw]

Thank you sir!
I also learned something new from your use of the asterisk.

Assuming that BankName field is a text field:

CountTrue: DCount("*","[tblBillSeats]","[BType] = True and
[BankName] = '" & [BankName] & "'")


--

Ken Snell
<MS ACCESS MVP>

My SQL Code is as follows:

SELECT tblBillSeats.BankName, tblBillSeats.BPseats, tblBillSeats.Pamt,
tblBillSeats.BTseats, tblBillSeats.Tamt, tblBillSeats.BType
FROM tblBanks INNER JOIN tblBillSeats ON tblBanks.BankName =
tblBillSeats.BankName
GROUP BY tblBillSeats.BankName, tblBillSeats.BPseats, tblBillSeats.Pamt,
tblBillSeats.BTseats, tblBillSeats.Tamt, tblBillSeats.BType;

1. I want to know how many values of BType are True, and how many are
False for each BankName.

2. I want to know how many BTypes there are for each BankName.

While I'm sure DCount is what to use here, I can't get anything to work.

This is giving me a syntax error:

CountTrue: DCount("[BillSeatsID]","[tblBillSeats]","[BType] = True and
[tblBillSeats]![BankName] = " & [tblBillSeats]![BankName])