Query/Report Totalling problem 1

[avagodro]

I work in an office for a Hospitality Company. At the end of each month, I need to enter postage figures for each of our properties for anything that was sent out for them.
This has been done in Excel for quite some time, and can be a real pain when adding or removing a property, since if I end up having to move one over, I have to reprogram formulas for numerous properties, not just for the one that I removed.
I know that something like this can be done in Access. I have created 2 tables - 'Properties' and 'Postage'. The properties table simply contains the information for the properties and a Primary Key for each record (PropertyID). In the postage table, I have PropertyID set as a number field and a relationship set up between the two set with 'Enforce Referential Integrity', and the other necessary fields: Date, Quantity, postage rate. The tables work fine.
What I need to do now is create a query that will create the grand total for the specified month for each individual property so that I can report on it. It would be fairly easy, except that I need to format the report on legal paper, landscape, with the date in the first column, then each of the properties located in across the page with the total displaying beneath the property code.
I tried a CrossTab Query, but it would only give me the totals for each day, and I was unable to get a total for the enter period I was reporting on.
Any suggestions?

 

[dhookom]

If you want totals by month change your [Date] column to something like:

YrMth: Format([Date], "yyyy-mm")
Group By
Row Heading

If you want to set criteria based on controls on forms, you must enter the parameter data types.
Query->Parameters
and enter something like:
[tt][blue]
[Forms]![frmRpt]!txtStart Date/Time
[Forms]![frmRpt]!txtEnd Date/Time[/blue][/tt]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]