Need to populate a Report with several records

B

Bill

In short, I have one report containing 5 records from the same table. The
individual records are layed out to support proper printing. I need to
populate each record with from the same table. I can not give them all the
same pointer to the table or I get 5 copies of the same record. How can I
populate those 5 records with 5 records from my table?
 
E

eeyore

I think you need to have a group by in your report. Thus you will get 1
group of data for each of the 5 that you are refering to as 5 records.
 
B

Bill

I am using a query but all 5 of the records are identical thus each record
pulled from the query populates all 5 records on the report identically
instead of sequentially. I may have to generate 5 different queries so as to
have a different source for each report record. I was hoping there would be
a bettery way.

bill
 
E

eeyore

What is the Primary key? Can you sort by it? What about sorting by a data
entry date and time?
 
B

Bill

In short, I have a query containing lets say 10 records. Each of the records
in the query consist of fields such as first name, last name, medicaiton,
dose, when to give, ect. I need to print all of those records onto the
report. The report is large enough to handle 5 records at a time in what I
call 5 slot areas. Each record on the report has to be placed at exact spots
for printing purposes. In the above case, I will need to print out 2 sheets
or records.

If I tell the report to use the single query containing all 10 records then
I have the problem of how to tell the report to use query record #1 for slot
1 and query record #2 for slot2 and so on. If I attach each lable on the
report to the same query then I would have slot1 (first name), slot2 (first
name)... slot5(fisrt name) pointing at the same data thus all 5 fields on the
report located in slots 1 - 5 would have the same data point.. not from
different records in the same query.

How do I get around thsi?

Bill
 
Top