Reports

[Asif]

I have a query that contains fields Bin Number, Quantity and Date. In
the month of March Bin Number 1 was used 5 times i.e. 5 different
entries, Bun Number 2 was used 6 times and Bin Number 3 was used 10
times. Now I've created a report based on this information where when
the user opens the report a dialog box opens up saying specificy which
month you want to view. When they select March the report opens up for
march but all the entries are shown and I only want the total being
shown for each bin number

Any ideas on what i'm doing wrong of if i'm not explaining clearly let
me know i'll try again

Thanks

 

[Guest]

Hi Asif,

You can likely use a totals query to return one record. In query design
view, click on
View > Totals. Change Group By to Sum for the field that includes your
numeric box data.

Another method would be to create a calculated text box control in the
report footer. Set it's control source: =Sum([FieldName]), where [FieldName]
is bound to a text box in the detail section of your report. Set the visible
property for the detail section to No.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________