I have a inventory database for which I have several locations which I go to and do a physical inventory. SO I have a locations table and an inventory_count table. I would like to create a report/layout that will display my ending count for each of the different locations by month.

Hi, Mazkot!

I would do the following:

locations table contains these fields: location_id location_name

inventory_count table contains these ones item_id inventory_date count

Assuming that you take one inventory count the last day of each month:

Layout for inventory_count:

Sub-summary by location_id

Sub-summary by inventory_date

Report:

California

1001 Gadgets

Jan 31 4

Feb 29 4

Mar 31 12

1010 Widgets

Jan 31 9

Feb 29 7

Mar 31 10

-----------------------------------------------------

Florida

1001 Gadgets

Jan 31 8

Feb 29 5

Mar 31 11

1010 Widgets

Jan 31 6

Feb 29 9

Mar 31 12

-----------------------------------------------------