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

  • Thread starter Thread starter david.isaacks
  • Start date Start date
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
 
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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting Records in Query Based on Value from Field Table 7
Subtotals every X number of records 4
Conditional formatting based on the value of another field 3
Putting 2 different record sets on the same report line. 1
Displaying info from multiple records in a report 7
Access Macro Repeat Expression using value of a field in table 0
want to add sum fields in different sections of a report 1
Enter data in multiple fields based on lookup? 4

Back
Top