creating exam seating arrangement (1 Viewer)

[vsk1975]

Sir I have a query with starting exam register number 344125 and ending registering number 344250. I would like to create a report as given below

344125 -- 344144
344145 -- 344164
344165 -- 344184
344185 -- 344204
344205 -- 344224
344225 -- 344244
344245 -- 344250
If a VBA code is necessary please Provide and help me. Thanks given in advance

 

[arnelgp]

ok, just follow this (i'll call your existing query, query1
and the exam registration number as "regno").

1. create a new simple select query using query1:

Seating: Partition(CLng([regno]),CLng(DMin("regno","query1")),CLng(DMax("regno","query1")),20)


2. on the ribbon, click on Totals.

run the new query and save.

to replace the colon ) with a dash (-), just
create yet another query taking the query above:

select Replace([Seating],":", "-") as Seating_Arrangement from theQueryNameAbove;

 

[vsk1975]

sir it displays for each register number .
by "regno" you mean starting register number or ending register number?
my query contains only starting and ending register number . sir could you please provide a sample db file (mdb file ) .thanks

 

[arnelgp]

If you a complete listing (not starting and ending only) in the table then use the table.

 

[vsk1975]

sir if i use such a table or query i get the above said arrangement for each register number. sir i need only the format indicated at the first request

 

[arnelgp]

Here is your samole db

 

[vsk1975]

Sir I know mere Thanks is not enough for your great help, yet I am very thankful to you .

 

[arnelgp]

Youre welcome.