Count in Control Sourse

A

AndyShuter

Registered User.

Local time

Today, 21:35

Joined

Mar 3, 2003

Messages

151

• Mar 4, 2003

• #1

I'd like to know how to count a certain number of records from a record set that equal a particular value - For example If I open a form and 20 of the 25 Records in the Town Field = Glasgow, how would I put that into the Control Sourse box to return the result??

All suggestions are greatly appreciated !

 

DES

Technoweenie

Local time

Today, 16:35

Joined

Apr 17, 2001

Messages

245

• Mar 6, 2003

• #2

Dcount("[Field Name]","table/query","[Field Name] = 'Glasgow'")

Of course it is more common practise to have the Glasgow in some other object on the form such as a text box or combo box in which case it would be:

Dcount("[Field Name]","table/query","[Field Name] = [Textbox/Combo]")

 

A

AndyShuter

Registered User.

Local time

Today, 21:35

Joined

Mar 3, 2003

Messages

151

• Mar 6, 2003

• #3

Still Not Working!

Thanks for the tip but it's not working.

Here's what I've entered - have I done someething wrong???

Here's my entry

DCount("[FinanceCoName]","qryalldeals","[FinanceCoName] = 'Paragon'")

Sorry to be a pain

Andy

 

A

AndyShuter

Registered User.

Local time

Today, 21:35

Joined

Mar 3, 2003

Messages

151

• Mar 6, 2003

• #4

Forgot to put the = sign before it - Doh!!

It's working now - many thanks

 

G

goaksmith

Registered User.

Local time

Today, 15:35

Joined

Jul 31, 2002

Messages

74

• Mar 10, 2003

• #5

Works but doesn't

I have put this formula into my control source. And it counts the number of Yes's in a record as it should. But the number does not change when I move to a new record. Is it the same as the number in the 1st record. What am I doing wrong?