Hello to all.
My name is Tess and I work with a team who train and distribute resources to Aboriginal people in remote communities who are developing community development strategies to reduce Alcohol and Other Drug abuse in their communities. I am new to access and we would like to have a simple database that records what we have, what category it is in, who took it, where it went and how many are returned. I have three tables only and a form for each table. We have about 300 resources in categories including merchandise, resources, books, loan items,and dvd
Table 1 - frmclient - name(dropdown box) and location(dropdown box)
Table 2 - frmstocklist - stock item(dropdown box), category(dropdown box), supplier(dropdown box) and comments(long text)
Table 3 - frmdisbursement - stock item(lookup from frmstocklist), date(date), taken by(lookup from frmclient), number taken(number) and number returned(number)
The reports I want is simply as below with the ability to search for a category or date range or person or stock item.
Report sample:
Category Stock Item Total Number Taken Total Number Returned Total Stock on hand
Category Stock Item Total Stock on Hand
Client Location Total Number Taken Total Number Returned (with date parameters for monthly reporting)
Date Range Stock Item Total Number Taken Total Number Returned
Any help would be most appreciated.
Tess