You tried to execute a query that does not include the specified
function as part of an aggregate function
SELECT Sum([amt]) AS Expr1, Testsales.orderid, Testsales.product,
Testsales.amt

I have a report that lists all attendees at a function with attendant
details.  I would like to be able to tell the report to pull a page for just
One of the attendees and not print the entire report.  Is this possible.  I'm
very new at access.  Please be gentle.

I have several subreports printing in my report. When I pull up the
subreport, it shows a value of 20 for the total; however, when I pull
up the report, it's showing a value of blank.
Can someone explain what I'm doing wrong?

Hi, Is there any way to print a selected page(s) in a report after its
previewing?
AK

I have a series room numbers which are geographically sorted so that rooms
1-10 are in one block, 11-20 in another block etc. Sometimes there are ten
rooms in a block, sometimes just 2 or 3.
I have a report that has a grouping interval 10 and a small footer so that

I have a report that displays a group by different teams.  I want the report
to color code the team in a report.  IS there a way to do this?

I am trying to have a field display different data depending on what one
field says.  the one field will contain 20 different options and based on
which one is chosen i would like another field to display something different
based on each option in the first field.

How to get reports to print with only 2 decimal places ?
Needless to say the control element "decimal places" does nothing
I've set what appears to be the relevant controls in the table itself and of
course in the form . In the text box that prints the problem data I call for

I need to pull the Value of a Label on a form to a Report.  I tried putting
this on the command button of the form after the report opens but it doesn't
work, I assume that its a timing issue, and unlike a textbox there isn't a
control property to put a value in.

I am trying to turn columns on an off in a report by using checkboxes
on another form (called frmAdvancedSearch). The code below is run when
the report is opened. I have named everything with numbers (chk1, chk2,
txt1, txt2 etc.) so that I can use a loop and save myself from writing

I am having problem when I transfer data from a Report to Excel.  Here is the
code that I am using:
   strWhere = "[Date] Between " & _
       Format(Me.txtStart, "\#yyyy\/m\/d\#") & " And " & _

I still do not get it completely with the report record source via the
'docmd.openreport'.
I created and sql statment in the variable stgFilter
 stgFilter = "" _

     I hope this makes sense. I have a report that I want to "hide" the
[DOSE] from [tbl_ORDERS] if the drug is listed on a different table,
[tbl_PCA]. There are only about ten so I put them on a separate reference
table as I thought it would be faster. The code below is in the ...

Folks,
I have a report based on outlets turnover. Records are grouped according to
outlets. There may be multiple outlets whose total should be calculated. I
tried running sum, but I am looking individual group sum not cumulative

Hi;
Probably a stupid question from a newbie;
I have a form with several test results taken during a 24-hour priod.
Each test has a field with time format like this: yyyy-mm-dd hh:mm. (not