Results 1 to 4 of 4
  1. #1
    arstueck is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jun 2014
    Posts
    2

    Calculating number of items based on dropdown

    I am trying to develop a database for a local clinic that is operating as a not-for-profit. I have a table that has the following fields

    AdmID - Autonumber


    PatientID - Number
    AdmType - Dropdown (based on another table) (Values are ER Visit, Admission, Readmission,... etc)
    Date - Date/Time
    Note - Memo

    The goal is to take the values from the AdmType field, group them, and then perform calculations based on those values. These are to be sorted by two user defined dates.

    I had originally had two fields "ParmValue:[Start_Date]" & "ParmValue2:[End_Date]" which would define the two dates needed.

    I'm open to Ideas I'm totally at a loss.

    Tables:
    Patients
    Admissions

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    A Crosstab query should do the trick along with your criteria.

    HTH

  3. #3
    arstueck is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jun 2014
    Posts
    2
    Alright I managed to create the crosstab as you suggested and now I have returned the values that I need, however I am unable to access the totals created by the crosstab to perform other calculations.

    The simplest of these calculations would be the (# of Admissions/Total patients) when I pull up the query wizard (or design view) I see no fields in the crosstab query.

    Thanks

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Are you using 2 tables and if so, are they correctly linked? Is there data in the tables?

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

Similar Threads

  1. Replies: 2
    Last Post: 06-25-2013, 08:35 AM
  2. Replies: 1
    Last Post: 03-05-2013, 06:53 PM
  3. Replies: 11
    Last Post: 05-28-2012, 05:47 AM
  4. Replies: 2
    Last Post: 08-03-2010, 10:16 AM
  5. Selecting multiple items from Dropdown
    By Kipster1203 in forum Forms
    Replies: 12
    Last Post: 06-07-2010, 09:20 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