Create Reports for more than one form

[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

 

[Rick B]

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

 

[Guest]

I tried it and and I am getting an error saying mismatch in expression.

 

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

 

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

 

[Rick B]

Please post your SQL for us to see.

--
Rick B

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?

 

[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

 

[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

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.

 

[Jeff Conrad]

I just added 12 more links to that section this evening.
That should keep them busy.
;-)

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: