Create Reports for more than one form

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
 
R

Rick B

Then create a query that includes all the tables and base your report on
that query.
 
R

Rick B

Which expression? What is the SQL of your query? Can you run the query by
itself or do you get the error? Details please.
 
G

Guest

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?
 
R

Rick B

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

Guest

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Access Form Refresh 1
Filtering Report Data 3
Report Based on Form Data 1
Reference controls on a dialogue form as the parameters 1
Report form/sub-form data... 1
How to Print a Subreport from a filtered search 1
Access Report Wizrad 2

Top