Dcount returning a 1 to all my my records on my form: Hel please

[sichilaba]

Hi..



Can someone help.

The dcount is returning a 1 in all the records on my form.
I using the dcount to rank the position of students in a class exam.

Here is expressin on my form
=DCount("*","senior report card","compflow<>" & [compflow] & " AND text359 >" & [text359])+1

Senior report card is the name of the table
compflow is the identification of the student and the data type is Auto
text359 is the unbound text which contains the expression =DCount("*","senior report card","compflow<>" & [compflow] & " AND text359 >" & [text359])+1

it is returning a 1 to all my records on the form

Where do l miss it

[CJ_London]

not clear what you are saying - the implication is that the formula in text359 is trying to use a value in text359

[sichilaba]

Good day Ajax

I would like to use the Dcount to rank the position of students in a class exam.

For example:

Name Scored Position
Jim 500 2
Ken 300 3
Jane 800 1
Silva 200 4
Joy 100 5

This is what l would like the dcount to do.

Please find attched of the the form print screen.

Thank you AjaxDcount Expression problem.pdfDcount Expression problem.pdf

[CJ_London]

it is not clear what you are calling the controls, but based on their labels you need something like

=DCount("*","[Senior Report Card]","[Scored]>" & me.Scored)+1

[sichilaba]

Hi Ajax

I have tried the expression you have just given me but its now returning the #Name

Where am l missing it Ajax. Can l send you the form you check on it?

[CJ_London]

if you want

[sichilaba]

Hi Ajax

Please can l send it via your email... I could not attache my database

[CJ_London]

have sent you a PM with my email

[sichilaba]

Hi Ajax

Please may l have your email so that l can email the database

Thank you

[CJ_London]

check you private messages

[sichilaba]

Hi Ajax

Have you received?

[CJ_London]

received email but db not attached - have responded to your email directly

[sichilaba]

Hi Ajax

I will try and Zip and send the file...

[sichilaba]

Hi Ajax

I sent the zipped file. Have you received?

[CJ_London]

have received and responded to your direct email