ms access-report

[umesh]

i have created a table whith containes date,start,end,kilo,rate,total. and
created a repoart. i dont want any duplicate date in this report and the
total=kilo*rate and all sum total should come in a box below.

kindly let me know how to do this

 

[Jeff Boyce]

Open the report in design view.

Open the properties of the (?)[Date] control (by the way, Access treats Date
as a reserved word -- rename this field/control for more consistent
results).

Find the property that lets you hide duplicates.

For the "total", add a new textbox in the Report Footer. Set its control
source property to something like:

=Sum([kilo]*[rate])

Good luck!
--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/