Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 849
  • Last Modified:

Serial no in MS Access report

How do i get the following serial no. in MS Access Report
1. XXX   a1    b1   c1
               a2   b2   c2
               a3   b3   c3
2. YYY    a1   b1   c1
               a2   b2   c2
3.  ZZZ   a1   b1   c1
               a1   b1   c1
0
Amitava_Mukherjee
Asked:
Amitava_Mukherjee
1 Solution
 
ErezMorCommented:
your question isnt clear enough
can you explain in further detail what is it your'e trying to do?
0
 
tbsgadiCommented:
Please give an actual example
0
 
Amitava_MukherjeeAuthor Commented:
Sl.No.    PM.      JobNo.    ClientName
1.          John     1001            ABCL
                            1091           RIL
                            2032           MISL
2.      Robert      1091           RIL
                            3033           TS
3.      Daniel       9999           MBL
                            1021            IIL
I want serial no only  group wise. As above, John have 3 rows but John appears only on top row . So we want serial no will populate only Project maneger's name wise not row wise.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you storing yoru SerialNumber somewhere in the database, or are you just looking for consecutive numbering of some sort (i.e. not based on data stored in your tables)?

If this is stored in the database, just build a Group based on the SerialNumber field, and add your various fields to that grouping level.

If this is not stored in the database, then you can add numbering to your query. The link below should show you how to do this:

http://www.msaccesstips.com/2010/01/auto-numbering-in-query-column.shtml

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now