If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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]) |
#2
|
|||
|
|||
DCount
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]) |
#3
|
|||
|
|||
DCount
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]) |
#4
|
|||
|
|||
DCount
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]) |
#5
|
|||
|
|||
DCount
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]) |
Thread Tools | |
Display Modes | |
|
|