Need to have a report with 1 of 5, 2 of 5 and so on

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

Guest

I'm a new user and have a bit of a situation. I need to have a report that displays a number of different results from different queries and tables. This is my situation, I need a report that looks at a specific city, the code associated with the city, and then it needs to look at the number of bundles of papers being sent to these citys and display 1 of 5, 2 of 5, 3 of 5 and so forth. The 5 comes from a form that I have set up with the name of the city, the total number of papers going to each city, the number of papers that will be placed in each bundle and then calculated the number of bundles, 5 being the number of bundles. The report needs to look at that 5, then make a report for each of those 5 bundles but each being 1 of, 2 of, 3 of and so on. I realize this may sound confusing, but trust me, it's been VERY confusing for me. Any help would be GREATLY appreciated.

Thanks
 
If you don't have a clear definition of what you want, it is very hard to
implement it.

I certainly do not get a clear idea of what you want from what you wrote...
what data do you have, how are your Tables structured, what information do
you want to display in the Report for the "1 of 5", etc.?

Data for Access reports does not come from Forms -- it comes from
tables or queries.

Larry Linson
Microsoft Access MVP

Nicole G. said:
I'm a new user and have a bit of a situation. I need to have a report that
Click to expand...
displays a number of different results from different queries and tables.
This is my situation, I need a report that looks at a specific city, the
code associated with the city, and then it needs to look at the number of
bundles of papers being sent to these citys and display 1 of 5, 2 of 5, 3 of
5 and so forth. The 5 comes from a form that I have set up with the name of
the city, the total number of papers going to each city, the number of
papers that will be placed in each bundle and then calculated the number of
bundles, 5 being the number of bundles. The report needs to look at that 5,
then make a report for each of those 5 bundles but each being 1 of, 2 of, 3
of and so on. I realize this may sound confusing, but trust me, it's been
VERY confusing for me. Any help would be GREATLY appreciated.
 
Back
Top