Hi guys,
just looking for a little help with building a report in access.
Basically im trying to create a report that will take a table with 3 columns(date, currency, value) and show them on a report. i want to group records by month and sum each month values to a single record. i guess its easy to do but i'm very new to access, any help or advise would be grateful.
thanks
stackieee.
here is a link to sample data(excel file)
http://www.mediafire.com/download.php?otmwn2mzwko
this is an image of what i'd like the outcome look like.