By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,326 Members | 2,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,326 IT Pros & Developers. It's quick & easy.

Record counts

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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...
Nov 13 '05 #3

P: n/a

"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") & "."

Nov 13 '05 #4

P: n/a
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.
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.