Can anyone see anything wrong with this?
=[Sum of txtDomfactotqtr]-(DLookUp("[Sum of
txtDomfactotqtr]","qryFDASalesv3v2","[txtmonthlabel] = #" & [txtqtr1] &
"#"))

I have a report with no control source that just displays 6 subreports.  I
would like to get a sum of a field within each of those subreports and
display it  in the report footer of the main report.  Can anyone help me?

I’m having a nightmare trying to create a calculated control in a report.
The control’s value should be calculated from other controls. The only
problem is that there is no report event to which I can attach the code!
For example, the Report Open event occurs before the data loads ...

I have a DB with a table of fungi records containing a number of fields
listing information on each fungi found (the ‘Record’ table).  Three of these
fields are "Family - Genus - Species".  These are each populated in the
"Record" table from a separate lookup table.  When a ...

I have 3 subreports, each with around 9 records displayed.  I want to add the
first values in all three of the sub-reports (to get a row total count).  
This works fine with referring to each of the sub-reports with:
=Reports![Main Report]![Sub Report1].Value+Reports![Main ...

I have a number of check boxes say 12, that I potentiality need to be
displayed on Access 97 reports. However, I know that for each report only a
few of the potential 12 will be used on each report. As report space is at a
premium, I do not want to display 12 check boxes on each ...

I've created a report with a sub-report that contains warranty data. The main
report contains a date that I need to replicate in the sub-report.
Issue: How can I have the sub-report automatically match the date entered in
the main report date field? These 2 dates need to match. I ...

Hi. I have a question. In my database I have an option group (gender) and I
want to calculate the total for each of them separetedly, like 10 students, 3
males and 7 females, in my report. All I can get is the total for both
together. Appreciate your kindness..

I've got a problem that I can't seem to solve.  I've got a form that I use to
input a date range for a crosstab query.  The results of the crosstab query
are then displayed in a report.  The query works just fine and I've got my
parameters defined, column headings specified, etc. ...

I am not sure if this is possible, but if it is I would sure like to know. Is
there some way to save a pdf file in access, almost like saving an OLE
object? We have a lot of PDF reports that come from other companies, and they
have specs and other information that we would like ...

Hi. I have a question. In my database I have an option group (gender) and I
want to calculate the total for each of them separetedly, like 10 students, 3
males and 7 females, in my report. All I can get is the total for both
together. Appreciate your kindness..

When I distribute new versions of Access 2002 applicaitons to clients, they
often have this problem:
Report shows up huge in print preview, and then prints on multiple pages.
They can sometimes resolve this by zooming, then closing the preview, then

I've created my first Access Data Base and I'm happy with the results in
Access (2003).  One of the reports I've set up uses Multiple YES/NO check
boxes.  The data for the boxes is entered through a form and has it's own
field in the table.  They show up in the report (both the ...

We receive information to complete projects, we put the dates the information
is received in a report so that we can keep track of them.  We want to print
the report sorting ascending so that the oldest date is at the top and the
ones that we haven't recd information at the ...

I would like to sort dates of information received ascending.  I can do that
only the blank dates are showing up at the top but I would like them to show
up at the bottom.  Is there any way to do that?