Text Box to Contain Calculations

Question

Here's my newbie Access developer question o' the day. 

I have a form where I want to display stats about a table. I'm going to start off with:

Minimum Date Created

Maximum Date Creted

# of Records

So I have those three labels on the form, each with a text box to the right of it. I want to use calculations or queries or something to fill the text box with the most up to date info. 

Need help. 

tod

Answer 1

Tod

Access has domain aggregate functions that do lots of things like that. The functions have 3 parts:

1. the field

2. the table/query

3. the criteria (WHERE clause without the word WHERE)

So to find the number of records all you do is use one as the ControlSource:

=DCount("*","myTable","FiscalYear='2015'")

Be sure to use an equal sign in frontof it. Check help for the other functions like DMax, DMin.

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals

Answer 2

Perfect. Easy, huh?

While I'm sort of on the subject, when I add a text box to the form it also adds the Text44 or whatever to the left of it. I don't want that. How do I delete it.

tod

Answer 3

Oh wait. I figured it out. You just highlight it and delete it. 

Answer 4

Perfect. Easy, huh?

While I'm sort of on the subject, when I add a text box to the form it also adds the Text44 or whatever to the left of it. I don't want that. How do I delete it.

tod

That's a label for the text box. You usually want that so the user knows what the text box is displaying. Highlight the label and then type whatever caption you want in the properties box. Or double-click the label and it becomes directly editable. 

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals