Just a quick note: Your module name can't be the same as the function name. Find and use a naming convention that prevents issues like this. -- Duane Hookom Microsoft Access MVP "Radhika" wrote: How can I add a function to an expression in query? I have the following expression: OPSE Avg All: (Nz([OPSE cracker Avg],0)+Nz([OPSE Pudding Avg],0)+Nz([OPSE 10 ml Avg],0))/CountItems

Hello, In mm_menu.js Change line 136: var itemProps = ''; To: itemProps = 'white-space:nowrap;'; That should work. If it doesn't, you can do it the long way: In mm_loadmenu.js, add   between each word or HTML element (like &amp). For example: BLACK & WHITE SCANNERS is changed to: BLACK & WHITE SCANNERS The code will

You will need to reference the objects correctly Reports![Name of your report]![Name of SubReport Control].Report![NameOfControl on subreport] You might be able to use ME![Name of SubReport Control].Report![NameOfControl on subreport] -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . "jenniebentham"

You can use a form to input the date range one time. Check out this article for a detailed discussion. http://www.fontstuff.com/access/acctut08.htm Or check out this from MS http://office.microsoft.com/en-us/access/HA011730581033.aspx Or for another example http://allenbrowne.com/ser-62.html You'll need to create a small unbound Form (let's call it frmCriteria) with two unbound

take a look at the DCount() function in Access Help, you can use it on a saved query object the same as you can on a table. hth "Koorosh" <Koorosh@discussions.microsoft.com> wrote in message news:45FD55CB-16FC-4623-908E-50DF6ED22DC0@microsoft.com... Hello everyone My task is to query a table in a VBA function and then return the count to the calling environment. How do I