I have a form where I want to put a sentence that says "you have (# of records from query) letters that need to be printed."

The query that I am referring to is called "letterstoprint"

How do I make it display the number of records in a query?

Is this query also the recordsource for this form ???

RDH

msgbox "You have " & Dcount("fieldInQuery","Queryname") & " letters that need to be printed."

This is a example of doing it in a message box

I could make it the recordsource, there is nothing elso on it because it is the main menu.

thanks, but i don't what it to be a message box, just a field in a line of text.

If there are not thousands of records return by the query .. use Danny's method.

RDH

Just use the approach as the Control Source of a txtbox on the form ...

RDH

Just out of interest Ricky at what point (how many records) would you move away from a Domain Aggregate Function in favour of specifying a recordset?

Normally I just open a recordset to get the value and avoid the domain aggregate functions as if they were the plague ...

RDH

I tried typing

& DCount("letter_printed","letter_need_printing") &

into the control source for the text box, but then the form says " #Name?"

I also tried it without the & symbols, but I get the same error. Am I supposed to be putting this somewhere else?

Try copying exactly what ricky posted, pasting it into the control source of a text box control and then changing the

("FieldInQuery","QueryName")

to

("letter_printed","letter_need_printing")

This assumes that your Query is called letter_need_printing and that in that query you have a field called letter_printed.

Ricky, Thanks for the insight - always nice to know other peoples methods, they may be better than the ones I currently use.

Cool! It works! Thank you both very much!

no problem