DCount

I use Access 2007

The following works fine, until the counting goes 10 and above

I want it the "CD" counted Ascending 1...8,9, 10, 11 and so on

What do I need to add to make it count in order from 10 and above

Enum: DCount("StuGenIndex","qryS12","CD=" & [CD] & " AND [StuGenIndex]=" &
[StuGenIndex])

On Wed, 8 Jul 2009 03:47:02 -0700, zyzzyva
wrote:

Enum is a reserved word; I would not use it for a column name.

Other than that, I cannot follow your question.

-Tom.
Microsoft Access MVP


I use Access 2007

The following works fine, until the counting goes 10 and above

I want it the "CD" counted Ascending 1...8,9, 10, 11 and so on

What do I need to add to make it count in order from 10 and above

Enum: DCount("StuGenIndex","qryS12","CD=" & [CD] & " AND [StuGenIndex]=" &
[StuGenIndex])

I changed "enum"

What I need is to make the qry code count those who are in various "CD"
categories, which it does up to a point as long as the count stops at 9

When a CD status goes 10 and above, the counting no longer is in sequence,
as say 1 through 20

It goes 1, then 10 say to 20, then picks back up with 2 through 9

I want the count to go from 1 to 20 (or whatever the count is above 9) in
count

"zyzzyva" wrote:

I use Access 2007

The following works fine, until the counting goes 10 and above

I want it the "CD" counted Ascending 1...8,9, 10, 11 and so on

What do I need to add to make it count in order from 10 and above

Enum: DCount("StuGenIndex","qryS12","CD=" & [CD] & " AND [StuGenIndex]=" &
[StuGenIndex])

That is strange since DCount should be returning a number. And if you
sort by the number returned you should have the records in number order.

Are you applying format to the number and trying to sort by the
formatted number? Using the format function turns a number into a
string and then you will get the sort order you mentioned since "11" (a
string) sorts before "2", while 11 (a number) sorts after 2.

'================================================= ===
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'================================================= ===


zyzzyva wrote:
I changed "enum"

What I need is to make the qry code count those who are in various "CD"
categories, which it does up to a point as long as the count stops at 9

When a CD status goes 10 and above, the counting no longer is in sequence,
as say 1 through 20

It goes 1, then 10 say to 20, then picks back up with 2 through 9

I want the count to go from 1 to 20 (or whatever the count is above 9) in
count

"zyzzyva" wrote:

I use Access 2007

The following works fine, until the counting goes 10 and above

I want it the "CD" counted Ascending 1...8,9, 10, 11 and so on

What do I need to add to make it count in order from 10 and above

Enum: DCount("StuGenIndex","qryS12","CD=" & [CD] & " AND [StuGenIndex]=" &
[StuGenIndex])

I am sure you are correct in your assessment

I went to the tbl this qry uses and changed "CD" to text, but, of course, it
messes up DCount it seems (I get an error msg), so I need to make my
expression "understand" to count "CD" as Text and no longer numbers, so it
seem

Do you see a possible update to my expression to account for this?

"zyzzyva" wrote:

I changed "enum"

What I need is to make the qry code count those who are in various "CD"
categories, which it does up to a point as long as the count stops at 9

When a CD status goes 10 and above, the counting no longer is in sequence,
as say 1 through 20

It goes 1, then 10 say to 20, then picks back up with 2 through 9

I want the count to go from 1 to 20 (or whatever the count is above 9) in
count

"zyzzyva" wrote:

I use Access 2007

The following works fine, until the counting goes 10 and above

I want it the "CD" counted Ascending 1...8,9, 10, 11 and so on

What do I need to add to make it count in order from 10 and above

Enum: DCount("StuGenIndex","qryS12","CD=" & [CD] & " AND [StuGenIndex]=" &
[StuGenIndex])