Search results

  1. S

    OpenReport But All Records Show Up

    Hey guys, What could be the problem with my Macro. In a Form I have a Subform that has more specific details including a TimeStamp Date() which i am using to open the report to a specific date which is usually NOW. I want to use a macro for OpenReport for the Current Patient from the MainForm...
  2. S

    Converting Excel Data&Chart to Access07 Table/Chart

    New To Access. I have a Data Table/Chart in Excel which I would like to incorporate into Access07. I would like the final Access Report to allow me to view the chart as in the picture for one specific record (patient) at a time combined with data from additional tables relating to this...
  3. S

    Combine Multiple Fields with a Twist

    The goal is to create a unique Patient ID based upon 2 separate fields from separate tables. I want to extract the last 4 digits of a social security number in a Patient Table and then combine those 4 digits with the PhysicianID (PhysicianTable) to create a unique PatientID which will be the...
  4. S

    Survey Calculations

    I am trying to calculate answers in a Risk assessment survey. If the person is Male and answers YES to a particular question then the question is given a specific pre-assigned numeric value for that question (0-5). If the person is Female and answers YES then they are given a pre-assigned...
Back
Top Bottom