not all records showing on report

A

angel82

I made my report from a query. My query is from 3 different tables. I enter the data in a subform. the records for the 1 subform show, but i only get one entry from the other. All the data shows in the query. Do i need to select something other than max for the fields that dont show?
 
D

Duane Hookom

Most of the time, if the data comes from a main form and more than one
subform, the proper method of displaying this information in a report is to
use subreports for the data from the subforms.

--
Duane Hookom
MS Access MVP


angel82 said:
I made my report from a query. My query is from 3 different tables. I
Click to expand...
enter the data in a subform. the records for the 1 subform show, but i only
get one entry from the other. All the data shows in the query. Do i need
to select something other than max for the fields that dont show?
 
A

Angel

Duan
Thank you for your response. I tried it and my records did show but I have a few questions, if you have a moment
1. I want to be able to add more fields in this report if neede
2. Should I make separate queries for each subform then make separate subform reports and add them to my main report
3. Each subreport will have a total of hours for each student. Will my hours fields have to be a number field? What I want to do is to combine these hrs from each subreport onto the main report for a total.
Would you be able to help me out here.
Thank you Duane you have been very helpfu
Ange

----- Duane Hookom wrote: ----

Most of the time, if the data comes from a main form and more than on
subform, the proper method of displaying this information in a report is t
use subreports for the data from the subforms

--
Duane Hooko
MS Access MV


angel82 said:
I made my report from a query. My query is from 3 different tables.
Click to expand...
enter the data in a subform. the records for the 1 subform show, but i onl
get one entry from the other. All the data shows in the query. Do i nee
to select something other than max for the fields that dont show
 
D

Duane Hookom

1) You can add more fields by going into object design views. Sometimes,
planning to add more fields suggests an un-normalized application.
2) I would base each subreport on its own record source. This could be
either a saved query or an SQL statement
3) You can total numeric values in a subreport and then reference the total
control on your main report:
=subreportControlName.Report.TxtTotalControlName

--
Duane Hookom
MS Access MVP


Angel said:
Duane
Thank you for your response. I tried it and my records did show but I have
Click to expand...
a few questions, if you have a moment.
1. I want to be able to add more fields in this report if needed
2. Should I make separate queries for each subform then make separate
Click to expand...
subform reports and add them to my main report.
3. Each subreport will have a total of hours for each student. Will my
Click to expand...
hours fields have to be a number field? What I want to do is to combine
these hrs from each subreport onto the main report for a total.
 
Top