Create Reports for more than one form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me if you can create one report for more than one
table/form? I have created a database with about 4 different tables and
forms. With each table I created another form and after I enter data into
each form I have a command button on the form going to the next table, which
seems to working fine. I just need to make a report for all the data that I
have entered into each form.

Thanks
 
Which expression? What is the SQL of your query? Can you run the query by
itself or do you get the error? Details please.
 
No it does not allow me to open it in datasheet view then the error comes up.
I have alot of data in all my tables, does this have something to do with it?
 
Please post your SQL for us to see.

--
Rick B



teelee said:
No it does not allow me to open it in datasheet view then the error comes
up.
I have alot of data in all my tables, does this have something to do with
it?
Click to expand...
 
Ok this is what I have showing in my SQL........Like I said there is alot of
data in these tables/forms.......SELECT Demongraphics.LName,
Demongraphics.FName, Demongraphics.MName, Demongraphics.SSN,
Demongraphics.[Date of Birth], Demongraphics.Gender, Demongraphics.Race,
Demongraphics.[Hispanic Ethnicity], Demongraphics.[History/Risk Factors],
[Diagnostic Studies].ID AS [Diagnostic Studies_ID], [Diagnostic
Studies].[Ejection Frac Asse], [Diagnostic Studies].[EF%], [Diagnostic
Studies].[EF TimeFrame], [Diagnostic Studies].[Electro Study Done],
[Diagnostic Studies].[EPS TimeFrame], [Diagnostic Studies].[EPS Findings],
[Diagnostic Studies].[No Arrhythmias Induced], [Diagnostic Studies].[VT
Induced], [Diagnostic Studies].[Non-Sustained VT], [Diagnostic Studies].[Sus
Monomorphic], [Diagnostic Studies].[Sus Polymorphic], [Diagnostic
Studies].[Ventricular Flutter], [Diagnostic Studies].[Ventricular
Fibrillation], [Diagnostic Studies].[Results Unattainable], [Diagnostic
Studies].[QRS Duration], [Diagnostic Studies].[PR Interval], [Diagnostic
Studies].[If Yes PR Interval], [Diagnostic Studies].[AV Conduction],
[Diagnostic Studies].[Abnorm-1 Degr Block Only], [Diagnostic Studies].[Abnorm
Block 2], [Diagnostic Studies].[Intraventricular Conduction], [Diagnostic
Studies].Normal, [Diagnostic Studies].[Abnorm Left Anterior Fascicular Block
Only], [Diagnostic Studies].[Abnorm LF Post Fas], [Diagnostic
Studies].[Abnorm RBBB], [Diagnostic Studies].[Abnorm LBBB], [Diagnostic
Studies].[Abnorm Intraven], [Diagnostic Studies].[Abnorm Bif], [Diagnostic
Studies].[Abnorm Bif Block + LPF], [Diagnostic Studies].Creatinine,
[Diagnostic Studies].BUN, [Diagnostic Studies].Sodium, [Diagnostic
Studies].[BNP Drawn], [Diagnostic Studies].[If Yes BNP], [Diagnostic
Studies].[Systolic BP], [History/Risk Factors].ID AS [History/Risk
Factors_ID], [History/Risk Factors].Syncope, [History/Risk Factors].[Family
Hx Sudden Death], [History/Risk Factors].CHF, [History/Risk Factors].[If Yes
- CHF Duration], [History/Risk Factors].[If Yes - Prior CHF Hosp],
[History/Risk Factors].[NYHA Class], [History/Risk Factors].[Cardiac Arrest],
[History/Risk Factors].[Brady Arrest Reason], [History/Risk Factors].[Acute
MI], [History/Risk Factors].[Severe Electro Disturbance], [History/Risk
Factors].[Drug Induced Arrhythmia], [History/Risk Factors].[Sinus Node
Dysfunction/AV Block], [History/Risk Factors].[Unknown Etiology],
[History/Risk Factors].[Tachy Arrest Reason], [History/Risk Factors].[Acute
MI II], [History/Risk Factors].[Severe Electro Disturbance II], [History/Risk
Factors].[Drug Induced Arrhythmia II], [History/Risk Factors].[Primary
VT/VF], [History/Risk Factors].[Unknown Etiology II], [History/Risk
Factors].[Atrial Fib/Flutter], [History/Risk Factors].[Vent Tachy],
[History/Risk Factors].[Sinus Node Function], [History/Risk Factors].[Cardiac
Transplant], [History/Risk Factors].[Non-Ischemic Dilated Cardiomyopathy],
[History/Risk Factors].[Ischemic Heart Disease], [History/Risk
Factors].[Previous MI], [History/Risk Factors].[Previous CABG], [History/Risk
Factors].[CABG Date], [History/Risk Factors].[Previous PCI], [History/Risk
Factors].[Prev Valvular Surg], [History/Risk Factors].[Perm PM],
[History/Risk Factors].[Prev ICD], [History/Risk Factors].[Prev ICD Date],
[History/Risk Factors].[Prev ICD Reason], [History/Risk Factors].[Primary
Prevention] AS [History/Risk Factors_Primary Prevention], [History/Risk
Factors].[Syncope w/Inducible VT], [History/Risk Factors].[Spontaneous
Monomorphic Sustained VT], [History/Risk Factors].[Spontaneous Polymorphic
Sustained VT], [History/Risk Factors].[Vent Fib], [History/Risk
Factors].[Cardiac Arrest/Arrhythmia-Etiology Unknown], [History/Risk
Factors].[Syncope/High Risk Characteristics], [History/Risk Factors].Afib,
[History/Risk Factors].[If Yes Previous ICD Implant Site], [History/Risk
Factors].Pectoral, [History/Risk Factors].Abdominal, [History/Risk
Factors].[Cerebrovascular Disease], [History/Risk Factors].[Chronic Lung
Disease], [History/Risk Factors].Diabetes, [History/Risk
Factors].Hypertension, [History/Risk Factors].[Renal Fail Dialysis], [ICD
Procedures].ID AS [ICD Procedures_ID], [ICD Procedures].[ICD Indication],
[ICD Procedures].[Primary Prevention] AS [ICD Procedures_Primary Prevention],
[ICD Procedures].[Secondary Prevention], [ICD Procedures].[Resaon(s) for
Implant], [ICD Procedures].[End of Batt Life], [ICD Procedures].[Device
Upgrade], [ICD Procedures].[Device Infection], [ICD Procedures].[Device
Malfunction], [ICD Procedures].[Device Under Manf Advisory/Recall], [ICD
Procedures].[Multiple ICD Implated during this admission], [ICD
Procedures].[If Yes - Reason for Device replacement during this admission],
[ICD Procedures].[Device Upgrade II], [ICD Procedures].[Device Infection II],
[ICD Procedures].[Device Malf II], [ICD Procedures].[Device Under
Advisory/Recall], [ICD Procedures].[ICD Type], [ICD Procedures].[Single
Chamber], [ICD Procedures].[Dual Chamber], [ICD Procedures].BIV, [ICD
Procedures].[If BIV LV Method], [ICD Procedures].[Coronary Sinus], [ICD
Procedures].[Epicardial Lead], [ICD Procedures].[Implant Oper LName], [ICD
Procedures].[Implant Oper UPIN], [ICD Procedures].Other
FROM ([History/Risk Factors] INNER JOIN ([Diagnostic Studies] INNER JOIN
[ICD Procedures] ON [Diagnostic Studies].ID = [ICD Procedures].ID) ON
[History/Risk Factors].ID = [Diagnostic Studies].ID) INNER JOIN Demongraphics
 
I would re-design your table to normalize them. You have a ton of fields
that are actually data values. For instance "Cardiac Transplant" should not
be a field name. This should be a value stored in a field. As long as you
continue to store data values as field names, you will continue to have
issues with your application.

Consider reading up on database design at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101.
--
Duane Hookom
MS Access MVP

teelee said:
Ok this is what I have showing in my SQL........Like I said there is alot
of
data in these tables/forms.......SELECT Demongraphics.LName,
Demongraphics.FName, Demongraphics.MName, Demongraphics.SSN,
Demongraphics.[Date of Birth], Demongraphics.Gender, Demongraphics.Race,
Demongraphics.[Hispanic Ethnicity], Demongraphics.[History/Risk Factors],
[Diagnostic Studies].ID AS [Diagnostic Studies_ID], [Diagnostic
Studies].[Ejection Frac Asse], [Diagnostic Studies].[EF%], [Diagnostic
Studies].[EF TimeFrame], [Diagnostic Studies].[Electro Study Done],
[Diagnostic Studies].[EPS TimeFrame], [Diagnostic Studies].[EPS Findings],
[Diagnostic Studies].[No Arrhythmias Induced], [Diagnostic Studies].[VT
Induced], [Diagnostic Studies].[Non-Sustained VT], [Diagnostic
Studies].[Sus
Monomorphic], [Diagnostic Studies].[Sus Polymorphic], [Diagnostic
Studies].[Ventricular Flutter], [Diagnostic Studies].[Ventricular
Fibrillation], [Diagnostic Studies].[Results Unattainable], [Diagnostic
Studies].[QRS Duration], [Diagnostic Studies].[PR Interval], [Diagnostic
Studies].[If Yes PR Interval], [Diagnostic Studies].[AV Conduction],
[Diagnostic Studies].[Abnorm-1 Degr Block Only], [Diagnostic
Studies].[Abnorm
Block 2], [Diagnostic Studies].[Intraventricular Conduction], [Diagnostic
Studies].Normal, [Diagnostic Studies].[Abnorm Left Anterior Fascicular
Block
Only], [Diagnostic Studies].[Abnorm LF Post Fas], [Diagnostic
Studies].[Abnorm RBBB], [Diagnostic Studies].[Abnorm LBBB], [Diagnostic
Studies].[Abnorm Intraven], [Diagnostic Studies].[Abnorm Bif], [Diagnostic
Studies].[Abnorm Bif Block + LPF], [Diagnostic Studies].Creatinine,
[Diagnostic Studies].BUN, [Diagnostic Studies].Sodium, [Diagnostic
Studies].[BNP Drawn], [Diagnostic Studies].[If Yes BNP], [Diagnostic
Studies].[Systolic BP], [History/Risk Factors].ID AS [History/Risk
Factors_ID], [History/Risk Factors].Syncope, [History/Risk
Factors].[Family
Hx Sudden Death], [History/Risk Factors].CHF, [History/Risk Factors].[If
Yes
- CHF Duration], [History/Risk Factors].[If Yes - Prior CHF Hosp],
[History/Risk Factors].[NYHA Class], [History/Risk Factors].[Cardiac
Arrest],
[History/Risk Factors].[Brady Arrest Reason], [History/Risk
Factors].[Acute
MI], [History/Risk Factors].[Severe Electro Disturbance], [History/Risk
Factors].[Drug Induced Arrhythmia], [History/Risk Factors].[Sinus Node
Dysfunction/AV Block], [History/Risk Factors].[Unknown Etiology],
[History/Risk Factors].[Tachy Arrest Reason], [History/Risk
Factors].[Acute
MI II], [History/Risk Factors].[Severe Electro Disturbance II],
[History/Risk
Factors].[Drug Induced Arrhythmia II], [History/Risk Factors].[Primary
VT/VF], [History/Risk Factors].[Unknown Etiology II], [History/Risk
Factors].[Atrial Fib/Flutter], [History/Risk Factors].[Vent Tachy],
[History/Risk Factors].[Sinus Node Function], [History/Risk
Factors].[Cardiac
Transplant], [History/Risk Factors].[Non-Ischemic Dilated Cardiomyopathy],
[History/Risk Factors].[Ischemic Heart Disease], [History/Risk
Factors].[Previous MI], [History/Risk Factors].[Previous CABG],
[History/Risk
Factors].[CABG Date], [History/Risk Factors].[Previous PCI], [History/Risk
Factors].[Prev Valvular Surg], [History/Risk Factors].[Perm PM],
[History/Risk Factors].[Prev ICD], [History/Risk Factors].[Prev ICD Date],
[History/Risk Factors].[Prev ICD Reason], [History/Risk Factors].[Primary
Prevention] AS [History/Risk Factors_Primary Prevention], [History/Risk
Factors].[Syncope w/Inducible VT], [History/Risk Factors].[Spontaneous
Monomorphic Sustained VT], [History/Risk Factors].[Spontaneous Polymorphic
Sustained VT], [History/Risk Factors].[Vent Fib], [History/Risk
Factors].[Cardiac Arrest/Arrhythmia-Etiology Unknown], [History/Risk
Factors].[Syncope/High Risk Characteristics], [History/Risk Factors].Afib,
[History/Risk Factors].[If Yes Previous ICD Implant Site], [History/Risk
Factors].Pectoral, [History/Risk Factors].Abdominal, [History/Risk
Factors].[Cerebrovascular Disease], [History/Risk Factors].[Chronic Lung
Disease], [History/Risk Factors].Diabetes, [History/Risk
Factors].Hypertension, [History/Risk Factors].[Renal Fail Dialysis], [ICD
Procedures].ID AS [ICD Procedures_ID], [ICD Procedures].[ICD Indication],
[ICD Procedures].[Primary Prevention] AS [ICD Procedures_Primary
Prevention],
[ICD Procedures].[Secondary Prevention], [ICD Procedures].[Resaon(s) for
Implant], [ICD Procedures].[End of Batt Life], [ICD Procedures].[Device
Upgrade], [ICD Procedures].[Device Infection], [ICD Procedures].[Device
Malfunction], [ICD Procedures].[Device Under Manf Advisory/Recall], [ICD
Procedures].[Multiple ICD Implated during this admission], [ICD
Procedures].[If Yes - Reason for Device replacement during this
admission],
[ICD Procedures].[Device Upgrade II], [ICD Procedures].[Device Infection
II],
[ICD Procedures].[Device Malf II], [ICD Procedures].[Device Under
Advisory/Recall], [ICD Procedures].[ICD Type], [ICD Procedures].[Single
Chamber], [ICD Procedures].[Dual Chamber], [ICD Procedures].BIV, [ICD
Procedures].[If BIV LV Method], [ICD Procedures].[Coronary Sinus], [ICD
Procedures].[Epicardial Lead], [ICD Procedures].[Implant Oper LName], [ICD
Procedures].[Implant Oper UPIN], [ICD Procedures].Other
FROM ([History/Risk Factors] INNER JOIN ([Diagnostic Studies] INNER JOIN
[ICD Procedures] ON [Diagnostic Studies].ID = [ICD Procedures].ID) ON
[History/Risk Factors].ID = [Diagnostic Studies].ID) INNER JOIN
Demongraphics
Please post your SQL for us to see.
Click to expand...
Click to expand...
 
Back
Top