DSum

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

Hello.

I already asked part of this question in another group
(probably the wrong group), but I'm still stumped.

I think I want to use the DSum function but I'm not sure
how exactly.

Here's my query:
SELECT tblMatl.MaterialDesc, tblMatl.MatlType,
tblMatl.MatlLocation, tblMatl.MatlNotes,
tblMatlActivity.Activity, tblMatlActivity.Qty,
tblMatlActivity.ActivityDate, tblMatlActivity.[Job/PO],
tblMatlActivity.Vendor, tblMatlActivity.DueDate,
tblMatlActivity.QtyIncmg
FROM tblMatl INNER JOIN tblMatlActivity ON tblMatl.MatlID
= tblMatlActivity.fkMatlID
WHERE (((tblMatl.MatlType)="Crop"));


I'm using this query as the basis for a report. In the
report I am summing the Qty field, and that works all well
and good right now since this is a new database. However,
when I start to accumulate records my report will become
unmanageable unless I can "archive" certain old records so
that they don't show up on the report (maybe with criteria
through my query). The problem is that I still need the
the total of all the records, including the archived ones.
I have my report grouped on "MaterialDesc", and I'd like a
total for each group, including the so-called archived
records. (I want to total all the records but display
only a few, to put it briefly.)

I've tried the DSum in an unbound field on my report in
the group footer, but it either gives me the total for all
the groups, or it gives me #Error, depending on my syntax.

Any suggestions?

Thanks in advance.
 
I would create a totals query that calculates the values you want on your
report. You can then add the totals query to your report's record source
query and join the MaterialDesc fields. This should make your calculated
sums available in your report.
 
Thanks a million Duane. That's just what I wanted!

Gina

-----Original Message-----
I would create a totals query that calculates the values you want on your
report. You can then add the totals query to your report's record source
query and join the MaterialDesc fields. This should make your calculated
sums available in your report.

--
Duane Hookom
MS Access MVP


Hello.

I already asked part of this question in another group
(probably the wrong group), but I'm still stumped.

I think I want to use the DSum function but I'm not sure
how exactly.

Here's my query:
SELECT tblMatl.MaterialDesc, tblMatl.MatlType,
tblMatl.MatlLocation, tblMatl.MatlNotes,
tblMatlActivity.Activity, tblMatlActivity.Qty,
tblMatlActivity.ActivityDate, tblMatlActivity.[Job/PO],
tblMatlActivity.Vendor, tblMatlActivity.DueDate,
tblMatlActivity.QtyIncmg
FROM tblMatl INNER JOIN tblMatlActivity ON tblMatl.MatlID
= tblMatlActivity.fkMatlID
WHERE (((tblMatl.MatlType)="Crop"));


I'm using this query as the basis for a report. In the
report I am summing the Qty field, and that works all well
and good right now since this is a new database. However,
when I start to accumulate records my report will become
unmanageable unless I can "archive" certain old records so
that they don't show up on the report (maybe with criteria
through my query). The problem is that I still need the
the total of all the records, including the archived ones.
I have my report grouped on "MaterialDesc", and I'd like a
total for each group, including the so-called archived
records. (I want to total all the records but display
only a few, to put it briefly.)

I've tried the DSum in an unbound field on my report in
the group footer, but it either gives me the total for all
the groups, or it gives me #Error, depending on my syntax.

Any suggestions?

Thanks in advance.
Click to expand...


.
Click to expand...
 
Back
Top