serial number

[akellaavss]

I have the following table and i need to generate the report from the table which includes serial number also


Table:
x 12
y 14
z 20
a 36
y 16
y 54
x 45

Report shall look like the following

Sl.No Name Marks
1 x 12
45
2 y 14
16
54
3 z 20
4 a 36

I am able to hide the duplicate values in name, However, the serial no. column needs to be adjusted as shown above.



pl. help in this regard.

[June7]

Adjusted how? Where does the 4 of "4 a 36" come from? Why do 45, 16, 54 just drop the alphas? What are the rules for 'adjusting'? How many different 'adjustments' are possible?

[akellaavss]

Sorry for not clarity in the question. I am enclosing the database. I need in the report the serial number shall be available based on the name only but not for all records.

Hope my requirement is clear

[June7]

Provides no help at all.

Nothing in the db looks like the output example in your post. Still have not addressed the questions I asked.

[orange]

I suggest you tell readers WHAT you are trying to do in simple English.
What are the things involved and what are the rules?

Before readers can give advice, they have to understand what you are trying to accomplish.
Good luck with your project.

[akellaavss]

I am really sorry, Since I am posting the question first time, I could not give the clarity. I hope the following tables explain my requirement.

My table contains the following data

Table1
Date	Gate pass	Name	qty
01-06-2015	451	abc	23
01-06-2015	451	abc	56
01-06-2015	452	xyz	15
01-06-2015	453	efg	25
02-06-2015	454	abc	25
02-06-2015	455	xyz	20
02-06-2015	455	xyz	25

I Want the report to look like below.

Sl No	Gate pass	Name	qty
Gate pass issued on : 01.06.2015
1	451	abc	23
			56
2	452	xyz	15
3	453	efg	25
Gate pass issued on : 02.06.2015
1	454	abc	25
2	455	xyz	20
			25

[orange]

Not really.

Why is it so difficult to tell us what you are trying to do in simple terms?

[akellaavss]

I am able to hide the duplicate values of gate pass no. and name in the report. However, the serial number shall be incremental by gate pass number but not on every record. (i.e for the second record in my report above, only quantity is visible, I set the property of name and gatepass to hide duplicates. however, i am not able to get the serial number as desired above.

[orange]

What is serial number? Where does it get valued?

[June7]

You want a sequence ID for each gate pass number and you want the sequence to start over for each date?

This would not be simple to do in query or on form.

A textbox on report has RunningSum property which can be used to generate a sequence ID. Use report Sorting & Grouping features to set groups for IssueDate and GatePass. Textbox in GatePass group header calculates the incrementing ID with ControlSource expression of =1 and RunningSum set to OverGroup.

Put Name and Qty fields in report Detail section.

Name is a reserved word. Should not use reserved words as object or field names.

[akellaavss]

Thanks for the reply. This I have tried and got it. However, the report print looks like stepped because of gatepass group header. Is there any other way of writing code for this.

[June7]

Other options:

1. save the sequence value in record when it is committed to table - this is generating a custom unique identifier - common topic in forum

2. VBA code to populate field for existing records

3. review: http://allenbrowne.com/ranking.html

[IrogSinta]

However, the report print looks like stepped because of gatepass group header

What do you mean by this?