sum field by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working with a report that I need to sum up a field by the month. The
database has information on inventory and orders taken, the majority of the
data is populated by either enter the orders in a form or entering the
inventory data

I need a report that is you put in a data range it will sort the number of
each inventory item and calculate the number received and the number used,
grouped by month. I have everything done except the part where it looks at
the data and then shows me the sum for each month. Any ideas would be
helpfull, it's been awhile since I did much in access and i'm a bit rusty.

Also is there a way to show a field that is not already part of the query or
table the report is linked to. I have tried using the controlproperties, I
choose the table the field is in and then the field that I need the data for,
but all I get is an error message.

Thanks so much for your help.
 
Tracie,
In the query behind the report, create a calculated field (example:
TransactionMonth : Month(YourDateField). Now use that bound field in
Grouping and Sorting to allow breaks on each TransactionMonth value... with
associated sums in the footer.

A text control on a report can utilize a DLookup to display data form
tables not associated with the report query.
If you have several fields of this sort, you could also use a subreport.
But... both of these methods require "some" realtionship between the
foriegn data you need to display, and the parent report.
Could you explain a bit more about that?
hth
Al Camp
 
Back
Top