I want to display the same records x number of times based on the value of a field.

D

david.isaacks

I want to display the same records x number of times based on the value
of a field.

[StatusJuly] has three values that could be entered into it. New,
Normal, or At Risk.

I want to run a report that list all the records based off of what
thier [StatusJuly] is.

New = 8
Normal = 4
At Risk = 8



Report

[FullName] [StatusJuly] [AssignedMonitor]


thanks,
David
 
D

Duane Hookom

A simple method would be to create a table
tblStatusCount
=============
[Status]
New
New
New
New
New
New
New
New
Normal
Normal
Normal
Normal
At Risk
At Risk
At Risk
At Risk
At Risk
At Risk
At Risk
At Risk

Add this table to your report's record source and join the Status field to
StatusJuly. You should get multiple copies of each record.
 
D

david.isaacks

Thank you, that worked for my needs.

David
Duane said:
A simple method would be to create a table
tblStatusCount
=============
[Status]
New
New
New
New
New
New
New
New
Normal
Normal
Normal
Normal
At Risk
At Risk
At Risk
At Risk
At Risk
At Risk
At Risk
At Risk

Add this table to your report's record source and join the Status field to
StatusJuly. You should get multiple copies of each record.

--
Duane Hookom
MS Access MVP

I want to display the same records x number of times based on the value
of a field.

[StatusJuly] has three values that could be entered into it. New,
Normal, or At Risk.

I want to run a report that list all the records based off of what
thier [StatusJuly] is.

New = 8
Normal = 4
At Risk = 8



Report

[FullName] [StatusJuly] [AssignedMonitor]


thanks,
David
Click to expand...
Click to expand...
 
Top