Search results for query: *

I'm not sure what the code looks like. Actually a better question might be, how to round or convert to currency within the query instead of a report. I have this calculation, Dividend Amount: ([Interest Paid]/29707084.37*10000000),in a query which carries the number out 11 decimal places...

Is there a way to get this formula to round up??? =ConvertCurrencytoEnglish([Text1]) Heidi

I think I have figured it out. I just needed to ask the question. Thank you!

I need to use a query for a mail merge, and I need to group records by Tax-ID. What is the best way to do this? Heidi

Tom and Paul, Thank you both for your suggestions. I believe adding the MyDate expression to the queries might be the best option for me. When I tried Tom's "Date Selector Form" method it seemed to affect some calculated text boxes in my report. Some text boxes worked correctly but the...

Tom, I run these reports quarterly, semi-annually, and annually. There are 54 reports that pull from 16 different queries. My date ranges change each quarter and I would like my report header to automatically update according to the date range I have entered in each of the queries. All of...

Paul Bricker, I'm a beginner in Access and have the same question as jer007 "I am running a report based on a query which requires the user to input a date range (Criteria: Between [start]AND [END]). This report displays the information within that range and sums the financial information. I...

Paul, I'm a beginner in Access and have the same question as jer007 "I am running a report based on a query which requires the user to input a date range (Criteria: Between [start]AND [END]). This report displays the information within that range and sums the financial information. I am...