Search results

I did your suggestions and I just realized that i had a 3rd Subform that has multiple imputs that was making the Report appear to report duplicates. I didn't notice it because it was so subtle. Your assistance has been fantastic.

An interesting thing has happened. I made an adjustment in the Expression builder for the Where Condition of the Macro. I selected In the Middle Column <Field List> and in the Right Column i chose the StartTime. This time I have the same record from the Form and Subform apear on the report...

How many records have the same date as [StartDate]=[Forms]![NewPatientForm]![NIASubForm].[Form]![StartDate] ? Typically Each Patient would have One Subform Completed on a given day. But we might have 50 separate Patients per day completing the subform. Try and create a query first, using the...

I am doing your suggestion however i still keep getting 100+ records. [Patient_Last_Name]=[Forms]![NewPatientForm]![Patient_Last_Name] And [StartDate]=[Forms]![NewPatientForm]![NIASubForm].[Form]![StartDate] I'm not seeing what I am probably missing. thanks again for your help.

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...

Once again, thanks for your imput. I created a query based upon the Survey Table. For Each Question I did used Expression builder to make Query Fields similar the following: Q1AMale: IIf([Sex]="Male" And [Q1-A]=Yes,3,0) Q1AFEMALE: IIf([Sex]="Female" And [Q1-A]=Yes,1,0) At the end I created...

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...

I sincerely thank each of you for your imput. I am working on this and will let you know how it turns out!

Thanks for your feedback. Yes this is a part of a database. We have patients who will answer this survey. Based upon the answers they will be categorized as LOW-MED-HIGH risk and then we will have a treatment plan based upon the risk level. I do have the "RiskAssessment" table with the 5...

Do i need to restate this or put this question in a different discussion board? I can also clarify if necessary. Thanks in advance.

Thanks for all of the replies. To answer this question. I am doing this more for Human Interfacing of the record. But i thought that while i have the number it could then become the Primary Key for the Patient. Also to clarify, the Physician is My customer and then the Patient is My...

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...

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...