I am trying to write a query that will group records by area by month
versus day. The current result breaks down by each day. How can I
change this query to achieve the desired results?
Here is the SQL query

I'm trying to get a Grand Total for multiple pages of a report. I have added
a field control that calculates the Price * Quantity for each row.
How do I get a Grand Total for all Price * Quantities  rows and put it on
the last page of the report?

I have a couple of hundred DSum functions pulling detail information in my
report.
Here is an example of one of them:
=nz(DSum("Amount","tbl_NUS1TaxYr2006","TaxType=""" & "accr" & """ and

In VB code, I execute:
DoCmd ReportName, acPreview,,WhereClause
WhereClause is a variable containing a valid statement, like
"Membertype = 5"

I am working with Windows XP ... Access 2003.  I have a report and I need the
text box to be formatted with text instead of dollars that the box is
formatted in my query.  For instance, in my query the dollar amount is
$170.00 ... I need the text box on the report to read 17000 . ...

I've got this code to build a report filter
Dim strWhere As String
strWhere = "[HR_SUPERVISOR2] Like """ & Me.cboSupv & " * """ _
Or "[HR_SUPERVISOR] Like """ & Me.cboSupv & " * """

Using the access 2000 wizard I have created a contact database. I now need
to create a label report using the company name field, so that it shows the
company and their addresses only once despite the multiple names under that
company.  How do I create the query?

Hi, is it possible to make column headers and column totals visible in a
subreport?
Thanks in advance,
AK

What is the best way to export a MS Access report to MS word or excel with
keeping most report's format.
Thanks,
John

I have a report that request a date range parameter from the user.  The
prompt comes from the query Criteria: Between [Enter Beginning Date]
And [Enter Ending Date]
I would like to display the dates parameters on the form in a text box.

Hope I can get some help because I'm really stuck with this one.
I created a form from Table1 that aks for Beginning Date / Ending Date /
Vendor.
I created a query from same Table1 with the following arguments.

I have a report that is giving me fits and there is probably a simple
solution.  Query has this expression which returns correct value:
ReceiptOfGoodsToNow:
IIf(IsNull([PriceQuote]),DateDiff("d",[ReceiptOfGoods],Now()),"")

I need help with a report.  I issue a certain number of "requisition
numbers" to a deparment.  For instance, the department has requested 5
sequencial numbers.  This sequence begins with 170011 and ends with 170015.
In a table I keep the next beginning number, so I don't need ...

I am trying to total prior years activity into a beginning balance
on a report using the DSum function as shown:
=nz(DSum("Amount","tbl_NUS1"," Year([PdYr])=2004 and Year([PdYr])=2005 "),0)
The PdYr column in table tbl_NUS1 is format Date/Time.

I posted something simular to this a couple of days ago, but it was very
confusing to say the least. I will try to make it more clear. I have a report
with a field of transaction dates, and a field with amounts for those dates.
My problem: How do you calculate a monthly average ...