Results 1 to 3 of 3
  1. #1
    Terresa is offline Novice
    Windows 8 Access 2016
    Join Date
    Nov 2017
    Posts
    1

    Help wanted to create simple reports from a very simple database using calculations and searches

    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

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Only 3 tables? What table is frmClient bound to - Clients? What is the RowSource of the Name combobox? What is the RowSource of the Location combobox? What is the RowSource for any of the comboboxes on any of the forms?

    Why would items be returned - are they only loaned assets, not consumed supplies?

    Treat each 'take' and each 'return' as a transaction. Each transaction will be a record.

    Review http://allenbrowne.com/AppInventory.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Some suggestions:
    Use only letters and numbers (exception is the underscore) for object names.
    Do not use spaces, punctuation or special characters in object names.
    Do not use look up FIELDS, multi-value fields or calculated fields in tables.
    Do not begin object names with a number.


    Do not use "Date" as an object name because it is a reserved word and a built in function in Access.

    Problem names and reserved words in Access
    http://www.allenbrowne.com/AppIssueBadWord.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-13-2016, 03:05 PM
  2. Wanting to create a simple database.
    By IAFerrari in forum Access
    Replies: 10
    Last Post: 09-24-2015, 12:38 PM
  3. Replies: 8
    Last Post: 10-10-2013, 11:01 AM
  4. Replies: 19
    Last Post: 12-02-2012, 07:01 PM
  5. Simple calculations to be shown in reports
    By Newaccessuser in forum Access
    Replies: 8
    Last Post: 03-03-2011, 06:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums