Office challenge: How can you show a total in an Access query?

Here's the answer to last week's challenge on generating random text in a Word document, along with a new question to test your Access query skills.

Can you display a total in Datasheet view? How about in a filtered Datasheet? You can do both, but there's more than one way — it just depends on your needs.

Last week, we asked:

"How can you fill a Word document with random text?" Several of you replied quickly, and pbrowning@... was the first to respond with the most comprehensive solution: Use the RAND() and LOREM() functions.

To insert random data, type =RAND(p,l) into the document where you want to position the text and press [Enter]. The p argument specifies the number of paragraphs and l determines the number of lines in each paragraph. Word 2007 offers a more robust function, the LOREM(p,l) function, which enters pseudo-Latin sample text. This function's arguments are the same as RAND()'s.

For a more comprehensive review of entering random sample text into a Word 2007, read How to insert sample text into a document in Word, a support document at


Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks