Record counts

[N J]

Hi,

How can I get a text box in a form to display how many records have NEWORDER
field as True?

Thanks..

--
Kind Regards,
Customer Services
Blue Bell Trading

[Bas Cost Budde]

N J wrote:

Hi,

How can I get a text box in a form to display how many records have NEWORDER
field as True?

Thanks..

See the Help on DCount. Set the controlsource for your textbox to
=dcount("*","yourtable","neworder=true")

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

[N J]

"N J" <bl*************@blueyonder.co.uk> wrote in message
news:Gy*******************@fe3.news.blueyonder.co. uk...

Hi,

How can I get a text box in a form to display how many records have
NEWORDER field as True?

Thanks..

--
Kind Regards,
Customer Services
Blue Bell Trading

Hi, Thanks...

That worked, any idea how I can get the first AutoNumber field and the last
autonumber field value's on record that have new order as true.

So it looks like this: Todays orders are 2500 to 2551.

Ta...

[Randy Harris]

"N J" <bl*************@blueyonder.co.uk> wrote in message
news:cY****************@fe1.news.blueyonder.co.uk. ..

"N J" <bl*************@blueyonder.co.uk> wrote in message
news:Gy*******************@fe3.news.blueyonder.co. uk...

Hi,

How can I get a text box in a form to display how many records have
NEWORDER field as True?

Thanks..

--
Kind Regards,
Customer Services
Blue Bell Trading
Hi, Thanks...

That worked, any idea how I can get the first AutoNumber field and the

last autonumber field value's on record that have new order as true.

So it looks like this: Todays orders are 2500 to 2551.

Ta...

DMin and DMax, just like you used DCount

="Todays orders are " & _
dmin("*","yourtable","neworder=true") & " to " & _
dmax("*","yourtable","neworder=true") & "."

[Salad]

N J wrote:

"N J" <bl*************@blueyonder.co.uk> wrote in message
news:Gy*******************@fe3.news.blueyonder.co. uk...

Hi,

How can I get a text box in a form to display how many records have
NEWORDER field as True?

Thanks..

--
Kind Regards,
Customer Services
Blue Bell Trading

Hi, Thanks...

That worked, any idea how I can get the first AutoNumber field and the last
autonumber field value's on record that have new order as true.

So it looks like this: Todays orders are 2500 to 2551.

Ta...

Dmax, Dmin.

Just remember autonumbers have have missing numbers within a range.

Let's say your max autonumber is 50. You open the form and one of the
date fields has a default value of Now(). You go to a new record. This
increments the autonumber to 51. You decide not use this record. The
next time you open the form to a new record the autonumber is 52.