not all records showing on report

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

Guest

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?
 
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
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?
 
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.
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
 
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
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
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.
 
Back
Top